Can I conditional format a chart?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Polister - 28 Nov 2005 21:46 GMT

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.

Reply to this Message

Ed Ferrero - 28 Nov 2005 22:53 GMT

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

> 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.

Reply to this Message