Create a Dynamic Moving Range

[jtaylo13]

Hi All,
I've created a dynamic range so that my graph will automatically grow whenever my macro runs and adds a new week of data to my table. However, now I'd like to have the graph show only the previous 6 months of data. I know I can do this by resetting the reference cell in my range every week, but is there a way to create a dynamic range that stays the same length and just moves with the data?

Thanks

 

[VoG]

This should help http://peltiertech.com/Excel/Charts/DynamicLast12.html