conditional formating of a chart?
 

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.

Hi,

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

Cheers
Andy

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.

--

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

conditional formating of a chart?
 

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

conditional formating of a chart?
 

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

conditional formating of a chart?
 

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

conditional formating of a chart?
 

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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



DonnaC wrote:
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...