Is it possible to change the color of a bar chart depending on the value of a
cell?

I want the bar graph to show 2 colors BUT would like for the colors on the
Provider bar to show Green above the 60% and show Red below 60%.

Member's bar to show Green above 80% and show Red below 80%.

Check this out:
http://peltiertech.com/Excel/Charts/...nalChart1.html

--
Best Regards,

Luke M
"jlo" wrote in message
...
Is it possible to change the color of a bar chart depending on the value
of a
cell?

I want the bar graph to show 2 colors BUT would like for the colors on the
Provider bar to show Green above the 60% and show Red below 60%.

Member's bar to show Green above 80% and show Red below 80%.