conditional formating of a chart?

[Guest]

Can you place conditional formats on charts? I know you can with cells but I
want a chart to reflect distinction between values > or < a chosen number.

 

[Andy Pope]

Hi,

The is no built-in CF for charting.
Have a look at John Peltier's work around.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy

 

[Guest]

Can you place conditional formats on charts? I know you can with cells but I
want a chart to reflect distinction between values > or < a chosen number.

You can kind of do it with a surface chart...

 

[Jon Peltier]

Here's how to apply conditional formats of a sort to regular charts:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

- Jon

 

[DonnaC]

Has Excel 2007 made any improvements for conditional formatting of charts or
is your solution below still the best alternative?

 

[Jon Peltier]

Excel 2007 did not introduce any features that would make this easier.
It's really not so hard, either, it just takes a bit more effort.

- Jon