Locate Source Pivot Table for PivotChart

bozack

New Member
Joined
Apr 9, 2002
Messages
9
OK, I have a spreadsheet I created a while ago with a lot of different pivot tables, charts and pivotcharts. I want to change a pivotchart, but I can't find the source pivot table. Unfortunately I have so many pivot tables in the file I can't find it. With a regular chart you can click on it and then click on source data and it shows you the source pivot table, but PivotCharts don't seem to have this option.
I'm running Office Excel 2003. Any suggestions greatly appreciated!!
 
Last edited:

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,108,924
Messages
5,525,665
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top