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" <(E-Mail Removed)> wrote in message
news9CABBE1-828D-43D6-BD8F-(E-Mail Removed)...
> 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%.