I have data on one worksheet that I want to display in different ways. That
data will be updated weekly. One of the ways is to make a bar chart of
filtered data, and I can accomplish this using a pivot table. I want a pivot
table of only the previous week's data. I don't want to trim the data in the
spreadsheet because I'm using all the data in other pivot tables, and I don't
want to duplicate spreadsheets. Whatever it is, it needs to be automated, so
when the data is refreshed, the charts update automatically. Any thoughts?