Chart Formatting

[pnwood]

I have a basic bar chart, say from 1 to 100 percent. I want to be abl
to format the bars of this chart based on the Data Value.


Example>
I three bars, 100%, 25%, and 50%, I want the 100% bar to be the defaul
color and any value under 50% be red.

In my charts I have a range of 15 to 60 Bars, this would kill me if
had to do this by hand. Any Ideas?

Thanks for the help..

 

[Andy Pope]

Hi,

Have a look at Jon Peltier's explanation of conditional charts.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy

 

[pnwood]

Thanks for the help..