Excel Guides

Positive and Negative Colors in a Chart in Excel

When it comes to charts in Excel, there are a few different ways that you can go about adding positive and negative colors. One way is to use the fill color option under the format tab. You can also use conditional formatting to add different colors based on whether the number is positive or negative.

If you want to use the fill color option, first select the cells that you want to add color to. Then, go to the format tab and click on the fill color drop-down menu. From here, you can choose to have all positive numbers be one color and all negative numbers be another color. You can also choose to have different shades of the same color for positive and negative numbers.

To use conditional formatting, first select the cells that you want to add color to. Then, go to the Home tab and click on Conditional Formatting. Choose New Rule from the drop-down menu. In the next window, select Format only cells that contain from the first drop-down menu. Then, select Cell Value from the second drop-down menu and choose greater than from the third drop-down menu. In the fourth field, type in 0 (without the quotation marks). Click on the format button and choose your desired fill color for positive numbers. Click OK twice to close out of both windows.

Now, select the cells that you want to add color to again. Go back to Conditional Formatting and choose New Rule from the drop-down menu. In the next window, select Format only cells that contain from the first drop-down menu. Then, select Cell Value from the second drop-down menu and choose less than from

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.