Can I conditional format a chart?

I've been looking for a way to conditional format a graph. I want a few items
to be a different color than the rest from the same set of data.
Been having to manually change each data point color (6 or 7 of 50 items),
just looking to see if i can automate it.

Hi David,

There is a conditional chart formatting example on my web siite at
http://www.edferrero.com/charting.aspx This uses VBA to copy Excel's
conditional formats to a chart.

Jon Peltier also has a sample at
http://peltiertech.com/Excel/Charts/...nalChart1.html
that does not use VBA.

Ed Ferrero

> I've been looking for a way to conditional format a graph. I want a few
> items
> to be a different color than the rest from the same set of data.
> Been having to manually change each data point color (6 or 7 of 50 items),
> just looking to see if i can automate it.