Re: $100 to change VB script to create a multi stacked waterfall chart
Hi Wigi -
I'm not sure what the best possible method would be. However, maybe instead of having 2 sheets or multiple sheets (if one were to have 3-4 data sets) we could just have one sheet where the user could use a drop down to select how many data sets he has. Then based upon how many data sets there are the file would then create multiple ranges as seen in B2:R25 to insert the data for each data set.
Take for example I wanted to graph 3 data sets -
1)I would select a drop down to let the file know i have 3 data sets.
2) I would enter each set of data in the respective tables
3) Hit a button to run a macro that would create 4 graphs - 1 graph for each data of the 3 data sets PLUS and all inclusive aggregated graph.
Does this make sense?