negative values in a waterfall chart
 

How do you display negative values in a waterfall chart? Everytime I have a
negative value in my data, the bar disappears off the chart.

negative values in a waterfall chart
 

Check this sample page:

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

The utility below accommodates positive and negative values:

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

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


"MelissaF" wrote in message
...
How do you display negative values in a waterfall chart? Everytime I have
a
negative value in my data, the bar disappears off the chart.