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

Hi,

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

Cheers
Andy

pnwood wrote:
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...



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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