Hi, you can create a new table as Luke M[_4_] said and then create Stacked Column Chart.
This may help:
http://excel-example.com/charts/cond...umn-bar-charts
Quote:
Originally Posted by
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 make
that bar green, if less then red, if same grey. Any ideas on how to go about
this?
Thanks
Adam Bush
|