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.
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