Excel Dynamic Chart series
Posted on 2012-04-11
I have a chart in Excel- one series formula is
However the range A2:A500 populated values can change - So sometimes I just need A2:A300 for instance
I have a formula to return the last cell address in the range A1:A500 that I want to use, but I dont know how to refernce that formula in the series - in this example in B1
something like =SERIES(BollingerBands!$A$1,B1,,3) - doesnt work, any ideas?