software

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

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 -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;fritz78quot; gt; wrote in message
...
gt;I have created an excel sheet that calculates the data for creating a
gt; waterfall type chart which is a stacked bar chart in graph with the bottom
gt; stack hidden. (Using IF statements, ABS formulas)
gt;
gt; Is there a way to make these type charts automatic by taking my calculated
gt; data and somehow have Excel generate the charts from this data. Maybe a
gt; menu
gt; driven way by entering this data with the variables for each different
gt; chart.
gt; Any suggestions would be appreciated.
gt;
gt; Excel 2002, Windows 2000
gt; THX Fritz78