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.

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"teach1" wrote in message
...
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.