Excel Help Needed: Showing the last 60 days of data in a chart without having to define a new range

[d|b]

I have a chart that show the last 60 days of data for several series. This data is displayed in a pivot table. The source data for the this pivot table is updated daily.

Every week I have to generate a report of the last 60 days worth of data. Is there a way of specifying a dynamic range that will will always look at the last 60 days of data?

p.s I am on excel 2007