Can I conditional format a chart?

[Guest]

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.

 

[Ed Ferrero]

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/ConditionalChart1.html
that does not use VBA.

Ed Ferrero