In Excel, you can find the source pivot table of a pivot chart as follows:
- Select the pivot chart that you want to find the source pivot table for.
- On the Ribbon, go to the "PivotChart Tools" tab (usually called "Chart Tools" or "Analyze" in newer Excel versions).
- In the "Data" group, click the "Select Data" button. This will open the "Select Data Source" dialog box.
In the "Select Data Source" dialog box, you'll see the name of the pivot table under "Chart data range." This will help you identify the source pivot table for your pivot chart.
Alternatively, you can also right-click on the chart and select "Select Data" to open the same dialog box.
This method allows you to quickly find the source pivot table for your pivot chart without needing to manually search through your worksheet.