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/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Courtney" wrote in message
...
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?
--
Many thanks!