I have a basic bar chart, say from 1 to 100 percent. I want to be able
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 default
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 I
had to do this by hand. Any Ideas?

Thanks for the help...


--
pnwood
------------------------------------------------------------------------
pnwood's Profile: http://www.excelforum.com/member.php...o&userid=20346
View this thread: http://www.excelforum.com/showthread...hreadid=495554