cfo tagline

Spreadsheets: Conditional Format a Chart

If you want to change the chart color for positive or negative, there is a built-in solution.

Bill Jelen, | US
January 5, 2011

Found what I needed to do

The last step (that I didn't see) was to Format Data Series, Series Overlap, Overlapped @ 100%

Posted by Brian Doennebrink | March 19, 2012 03:58 pm

THis didn't work for me

Using Excel 2010, the #N/A values did not prevent those columns from being drawn (they were labeled, as there are Wednesday and Thursday values for "Good." Instead what happened was, for Monday, Tuesday, and Friday, a blank spot (imagine an invisible column) resulted, with the "Bad" column pushed to the right, the opposite for Wednesday and Thursday. Bottom line: the columns weren't equally spaced.

Posted by Brian Doennebrink | March 19, 2012 03:27 pm

2007 Conditional Format Solution

You can still conditionally format a chart to be red for negative numbers and green for positive numbers in Excel 2007; however, there are a couple extra steps. Below is a link to a youtube video that does a better job of explaining how to do the conditional formatting than I could post in a comment. Just remember that for positive values to be green, you still need to select "Solid Fill" and then choose green. Also, you will probably choose to hide the legend for presentation purposes. Link:

Posted by Kelly Wedge | January 11, 2011 09:20 am

Unable to view options

Evn i am unable to view the option for selecting two colors for +ve and -ve values. Request u to clarify the same.

Posted by Dipesh Mehta | January 09, 2011 12:02 pm


yeah I've figured that it's built-in feature in Excel 2010 not 2007

Posted by Thomas Kavlovitz | January 06, 2011 05:44 pm

one problem here

For some reason in 'format data series' I don't get the second dropdown menu to choose the color, even though solid fill is ticked..

Posted by Thomas Kavlovitz | January 06, 2011 05:18 am

CFO Publishing Corporation 2009. All rights reserved.