negative values in a waterfall chart

[Guest]

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.

 

[Jon Peltier]

Check this sample page:

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

The utility below accommodates positive and negative values:

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

- Jon

 

[Jon_Peltier]

I've revised the Waterfall/Bridge Chart tutorial; see Excel Waterfall Charts (Bridge Charts).

 

[jacqueslegrand]

You can create easily a waterfall chart working with negative values online, and for free - you will receive the chart by email. The website doing this is the following: www.waterfall-chart.com
Jacques