Excel bar chart formatting of bars to change colors as data change
 

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

Excel bar chart formatting of bars to change colors as data change
 

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