How to make a waterfall chart

[Guest]

I have to create a Waterfall chart (not to be confused with a cascade chart)
like the one shown at
http://www.ozgrid.com/Services/excel-waterfall-chart.htm. This is just a
one-time deal, and I don't feel like buying the add-in. I would rather learn
how to do it myself. Does anybody know how?

Thanks!

Lucas Bravo

 

[Frank Kabel]

Hi Lucas
have a look at
http://www.tushar-mehta.com/excel/charts/waterfall/index.htm
http://peltiertech.com/Excel/Charts/DummySeries.html#Falls
http://peltiertech.com/Excel/Charts/DummySeries.html#Fall2