Display negative data points differently.

[Guest]

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]

Jon Peltier has instructions for conditional charts:

http://www.peltiertech.com/Excel/Charts/ConditionalChart1.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