Display negative data points differently.
 

How do I change the color or format of a line and/or bar so that negative
numbers in a data series are displayed differently.

Specifically, I would like to draw more attention to a series when it
crosses the -0- line because this particular chart displays 4 separate
series' already.

Jon Peltier has instructions for conditional charts:

http://www.peltiertech.com/Excel/Cha...nalChart1.html

Andy Pope has instructions for inverting negative values:

http://www.andypope.info/charts/Invertneg.htm

And for conditional line charts:

http://www.andypope.info/charts/conditionalline.htm

MRN wrote:
How do I change the color or format of a line and/or bar so that negative
numbers in a data series are displayed differently.

Specifically, I would like to draw more attention to a series when it
crosses the -0- line because this particular chart displays 4 separate
series' already.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html