View Single Post
Old June 2nd, 2010, 09:00 PM posted to microsoft.public.excel.charting
Luke M[_4_]
external usenet poster
Posts: 451
Default Column Chart Conditional Formatting

You'll need to do this by manipulating the actual data.

Setup 3 dummy series, first with a static value of 10. On the chart, format
these green, red, and grey respectively. Now, go back and change the static
values to formulas similar to this:




If your chart has a legend, you can remove the dummy series by
single-clicking twice on the entry, and then press delete.

Best Regards,

Luke M
m wrote in message
I have a column chart that compares 2 y values against a common x value. I
want to compare the second y value to the first, if it is greater then
that bar green, if less then red, if same grey. Any ideas on how to go


Adam Bush