How to create a dynamic chart with sliding X axis

[scottb80]

I've been trying to create a dynamic line chart for a data series that consists of about 24 months of data. I've used Named Ranges with Offset/Counta, and a scroll bar to move the chart, but in all cases, the starting date of the chart is fixed, due to the Offset command requiring a cell reference in it's first variable. What I want to accomplish is a chart that displays six months of data at a time, and a scroll bar that will allow the user to scroll throught the 24 months of data, back and forth, one month at at time.

I tried using something like =OFFSET(ADDRESS(variable,variable), etc. but this wouldn't work.

Any help would be aprreciated.

 

[scottb80]

Never mind, I found exactly what I was looking for here:
http://whatapalaver.co.uk/2007/10/scroll-bar-chart/

Thanks!