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

 

[Malakite]

build another data set from your original.

So on a different tab have your date field set to today()-1 then for each cell under this just -1 the cell above for 60 rows.

This wil give you the dates for the last 60 days. Then just use vlookups to find the corresponding data for each date in your main data set.

This will give you a data page that always shows the last 60 days. From this data set build a pivot table or graph etc that will constantly show the correct data.

 

[Participant]

This is probably how I'd do it:

The today's date cell has a =TODAY() formula in it.