Waterfall Charts - Automation

[Guest]

I have created an excel sheet that calculates the data for creating a
waterfall type chart which is a stacked bar chart in graph with the bottom
stack hidden. (Using IF statements, ABS formulas)

Is there a way to make these type charts automatic by taking my calculated
data and somehow have Excel generate the charts from this data. Maybe a menu
driven way by entering this data with the variables for each different chart.
Any suggestions would be appreciated.

Excel 2002, Windows 2000
THX Fritz78

 

[Jon Peltier]

Excel has no native way to accomplish this, but if you Google 'Excel
Waterfall Chart', you will come across several addins that have been created
to do just this.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______