Color Change in chart based of condition
 

Dear All
I have plotted a chart where there is a target value for the whole year and
mothly actual values and their avg is plotted. Now I need to show the
performance in green if year to date (YTD) value exceeds the target. If YTD
is equal then I want to show it as yellow otherwise in green. I know this can
be done on the data table with conditional formatting but how to do the same
for the bar chart? I will appreciate reply from any genius out there who
knows this.
Thanks in advance for your inputs.

Regards

Conditional Charting:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


KRT wrote:
Dear All
I have plotted a chart where there is a target value for the whole year and
mothly actual values and their avg is plotted. Now I need to show the
performance in green if year to date (YTD) value exceeds the target. If YTD
is equal then I want to show it as yellow otherwise in green. I know this can
be done on the data table with conditional formatting but how to do the same
for the bar chart? I will appreciate reply from any genius out there who
knows this.
Thanks in advance for your inputs.

Regards