cumulative bar chart- (multiple x axes?)

[PBcorn]

I want to set up a bar chart where adjacent columns are cumulative, i.e. say
the first column value is -150, the column immediately to the right of this
starts at -150 and extends to its value, eg. if it was -50, it would extend
from -150 to -200. And so on for all the other columns.

Any help appreciated.

 

[Ed Ferrero]

Hi PBcorn,

I want to set up a bar chart where adjacent columns are cumulative, i.e.
say
the first column value is -150, the column immediately to the right of
this
starts at -150 and extends to its value, eg. if it was -50, it would
extend
from -150 to -200. And so on for all the other columns.

Any help appreciated.

I suspect this is a waterfall or cascade chart.

Try these links
http://peltiertech.com/Excel/Charts/format.html#Falls
http://www.tushar-mehta.com/excel/charts/waterfall/
http://www.sccs.swarthmore.edu/users/06/adem/engin/excel/waterfall_chart/index.php
http://www.edferrero.com/Content/Scatter_Waterfall.xls

Ed Ferrero
www.edferrero.com