Hi Forum,

My previous co-worker has produced several pivot charts.

I was trying to find out what pivot table data sources s/he has used for pivot charts.

1). I right clicked on the chart.
2). Then clicked on “Select Data”
3). Then “Select Data Source” dialogue box appeared.
4). Then there is a box called “Chart Data Range”
5). In that box, the name of Excel file and the specific tab used for creating the chart are shown in grey colour.

The name of the excel file and the name of tab the co-worker used for the pivot chart are too long to fit in “Chart Data Range”, so I can see only a part of the story.

Q:
From 5) above, I can guess the specific tab used for the pivot chart but that specific tab is having a number of pivot tables, which makes me difficult to find which exact pivot table was used.

Is there any other method?

Thanks for your expertise.
Mirisa