Pivot charts

T

teach1

Having created a chart from a Pivot Table, how can you tell which pivot table
is the source of the chart if there are several pivot tables in the workbook.
 
J

Jon Peltier

Click on a series. You will see the source data range in the series formula.
This lies within the parent pivot table.

Alternatively, click on Pivot Chart on the Pivot Table toolbar, then select
Options. The name in the top box of the dialog matches the name of the
parent Pivot Table. To see the name of a pivot table, click on Pivot Table
on the Pivot Table toolbar, then select Table Options, and look in the top
box of the dialog.

- Jon
 
Top