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
>