Waterfall Charts - Automation

F

fritz78

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
 
Top