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