View Single Post
  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

Pablo -

You need to add more series to account for negative values. I have
another page describing stacked column charts that have to cross the
axis, which you can combine with the waterfall charts technique:

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

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

Pablo wrote:

Hello:

Anyone have any ideas how to make a waterfall chart that can break below the
Y-axis? Jon Peltier has a good example of an automatic waterfall chart, but
I can't figure out how to make it go negative.

Thanks!