Organizing Numerous Pivot Table / Pivot Charts

[muzikman69]

I have started to create some reports which have grown to include numerous Pivot Charts within them. What I am finding is that I have quite a few pivot tables over in the right hand columns of a worksheet (driving the charts); and it is becoming increasingly difficult to keep them organized.


Does anyone have any technique they use to manage numerous pivot tables which are driving pivot charts for reports?

Do you keep them on a separate worksheet or off to the right of the charts themselves?

Is there an easy way to identify which pivot table drives which chart, I can go into select data and it will show me the pivot table #... but not much else.


Thoughts?


Cheers,
Graeme,

 

[JD_GFI]

Hi Graeme,

I usually keep pivot tables on one sheet and the charts on a separate sheet. To aid matching table to chart I name them both the same (Pivot table name field is under the Options menu with the table highlighted, chart name is under the Layout menu with the chart highlighted)

Hope this helps,

JD

 

[muzikman69]

Ahhhh.... the simple things like renaming pivot tables.... I never noticed that on the ribbon.


Thanks,
Graeme,