Hi,

Have a look at these site on conditional chart formating.

http://peltiertech.com/Excel/Charts/...nalChart1.html
http://www.edferrero.com/charting.aspx

Cheers
Andy

glennr wrote:
I need to graph a bar chart with conditional colors and then overlay another
series of bars which also have conditional coloring.

I can only figure out how to get one set of conditional bars with diferent
colors, but not the 2nd series.

--

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