- Sep 27, 2007
Using XL 2010, I am able to format a bar chart data series with two different colors if some of the values are negative. Checking the 'Invert if negative' box allows me to choose colors for positive and negative values. Ideally, I'd like to create bar charts that are two colors with a qualifier other than positive/negative. i.e.: Green bar if data point is equal to or greater than 10 and red if data point is below 10. Is there any way to do this?