If you want to change the chart color for positive or negative, there is a built-in solution.
Bill Jelen, CFO.com | US
January 5, 2011
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
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
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: http://www.youtube.com/watch?v=N1N1lZdjvlA
Posted by Kelly Wedge | January 11, 2011 09:20 am
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
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.