View Single Post
  #3  
Old July 15th, 2010, 10:06 AM
elliott.matthew elliott.matthew is offline
Member
 
First recorded activity by OfficeFrustration: Jul 2010
Posts: 4
Default

Quote:
Originally Posted by Luke M[_4_] View Post
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(B2A2,B2,NA())

=IF(B2A2,B2,NA())

=IF(B2=A2,B2,NA())

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
"
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
make
that bar green, if less then red, if same grey. Any ideas on how to go
about
this?

Thanks

Adam Bush
Great and informative information provides here with and I want add the step could easily be incorporated into a macro, but the real focus of this technique is setting up the conditional formatting.And useful and easy to utilise also .