Is there code which will allow me to create a stacked bar graph (the intention is to end up with a waterfall graph) from two series of data, without having to select the range each time new data is added to the range of source data for the series.

For Example:

The range might be A1:A4 for Series1 and B1:B4 for Series2 for the source data below

Profit04: Series1 Data = 0, Series2 Data = 8

Sales: Series1 Data = 8, Series2 Data = 4

Margin: Series1 Data = 12, Series2 Data = (2)

Profit05: Series1 Data = 0, Series2 Data = 10

I now insert another row (as shown below) to my series of data and I need the range for Series1 and Series2 to update automatically to A1:A5 and B1:B5 respectively.

Profit04: Series1 Data = 0, Series2 Data = 8

Sales: Series1 Data = 8, Series2 Data = 4

Margin: Series1 Data = 12, Series2 Data = (2)

Tax: Series1 Data = 10, Series2 Data =(2)

Profit05: Series1 Data = 0, Series2 Data = 8

Any suggestions/help would be appreciated.