Charts

[Courtney]

Okay, I have a bar chart that has multiple bars referencing different named
sites. I want to single out some bars and format the color of the bar without
selecting each individual bar to color leaveing the others the defaulted
color. How can I do that?

 

[Jon Peltier]

This might be easier. This example shows how to make conditional charts. Use
a dummy column of cells, and put a 1 in the cell corresponding to a bar you
want to color differently. Your condition will test whether there is a 1 in
the cell.

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

- Jon