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

"Jon Peltier" wrote:

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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"mikeweasel" wrote in message
...


"JohnA" wrote:

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