dynamic chart without offset

[tlindeman]

I need to add a month to a chart every month without using the offset in excel 2007. I am willing to use VBA, I just do not know the code. What I have is data from Dec-2010 through OCT-2012 (forecasted). Next month I need to add through Nov-2012. My cell in G37 states: =IF(TODAY()>G20,DATE(2012,11,1)," ") So I would like my chart to look through I14:I36, next month I need it to look through I14:I37. Any ideas? I can't use offset, it will not work in this case.

Thank You
Tony

 

[Steve=True]

Not sure why offset wouldn't work.

Have you tried using Index and match vs Offset?

http://www.contextures.com/xlfunctions03.html