How do I conditionally format a chart?

Midavalo · February 21st, 2006, 06:43 AM posted to microsoft.public.excel.charting

I need to format a chart in Excel so that values in certain ranges (such as
0-19, 20-39, 40-59...) are shown in different colors. There are too many
records to change each one manually, and some also may change, so the
formatting would change too. I know how to condionatlly format cells (which
works fine), but I can't get that to be shown in the chart.

Thanks,
M.

Andy Pope · February 21st, 2006, 10:10 AM posted to microsoft.public.excel.charting

Hi,

You can create conditional charts by using extra data series for each
colour required and some worksheet formula.

Here are some links on conditional charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html
http://www.edferrero.com/charting.aspx

Cheers
Andy

Midavalo wrote:
I need to format a chart in Excel so that values in certain ranges (such as
0-19, 20-39, 40-59...) are shown in different colors. There are too many
records to change each one manually, and some also may change, so the
formatting would change too. I know how to condionatlly format cells (which
works fine), but I can't get that to be shown in the chart.

Thanks,
M.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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
pasting chart shows chart area, not the chart	Pirjo	Powerpoint	3	October 13th, 2005 04:31 AM
Why Does Date Format Change on Chart	John Taylor	Charts and Charting	2	September 14th, 2005 06:30 AM
Chart Format generated from a Pivot Table Data	Victor	Charts and Charting	1	October 20th, 2004 05:58 AM
Stop Chart Style (Format) Update	Kevin McCartney	Charts and Charting	1	July 12th, 2004 06:07 PM
Chart menu visible property	Sandy V	Charts and Charting	8	May 17th, 2004 01:39 PM