Can I conditional format a chart?

David Polister · November 28th, 2005, 09:46 PM posted to microsoft.public.excel.charting

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 · November 28th, 2005, 10:53 PM posted to microsoft.public.excel.charting

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Office2000: Conditional format behaves strangely	Arvi Laanemets	General Discussion	1	April 7th, 2005 08:47 AM
How to carry over conditional format colors to a chart	Tim A	Charts and Charting	1	April 1st, 2005 12:59 AM
Chart Format generated from a Pivot Table Data	Victor	Charts and Charting	1	October 20th, 2004 05:58 AM
Conditional format number	goss	General Discussion	1	October 8th, 2004 03:53 PM
Conditional format to hide #N/A	Ann Scharpf	Worksheet Functions	3	October 21st, 2003 02:42 PM