S
simkota
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?
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?