The easiest way doesn't require programming, just some extra series:

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

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


"JudyT" wrote in message
...
Is there an option or function that when data changes for the bar that it
is
referring to changes, it will change colors. I.e. conditional formatting
for
the bar.

Example: If the data reflects <75% the bar that it refers to in the bar
chart, needs to change to red. Then if the data reflects 75% the bar
that
it refers to in the bar chart, needs ot change to green.

Is this possible?
JudyT