Pivot table save

I have a pivot table I have to create a number of graphs from at the begining of each month. Each graph requires the data to be cut up a different way. Can I save the current query as a name and then just cycle through the names to generate the data each month?
titanium123Asked:
Who is Participating?
 
duttcomCommented:
Pity the pivot graphs don't work well. Does the source data need to be a pivot table, or could you use a regular table instead?

You say this happens monthly - does more data get added (hence the need to filter out older months) every month?

The other thing you could look at is using a Power Pivot instead. You can then use the named sets feature (PivotTable Tools -> Options tab-> Fields, Items & sets. That will allow you to save sets of columns (or rows) to display or hide, which may save you some time if your layout involves different columns being active.
0
 
duttcomCommented:
You haven't said where the data from your Pivot table comes from, but you could try using pivot graphs instead of regular graphs (Insert tab, then click the arrow under pivot table to select pivot graph).

You can give a pivot graph the same data source as the pivot table and then give each graph the required pivot settings to create the graph. When the data source changes, so will the graphs automatically, just like a pivot table.
0
 
titanium123Author Commented:
the data is in the same excel sheet, the pivot graph thing doesn't work real well in this case. I'm more looking to be able to take a snap shot of the pivot table at that point and be able to quickly replicate the data layout and specifics each month to then export the data.
0
 
titanium123Author Commented:
thanks power pivot helps
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.