» Create and Insert Additional PivotTable Reports Using the Same Data Source in Excel 2007

To create and insert several PivotTable reports using different structures from one data source:

Quickly create several PivotTable reports by copying the sheet where the PivotTable report exists.
1. Right-click the sheet tab of the PivotTable report.
2. Select Move or Copy -> select the sheet name, check Create a Copy and click OK.
Or
Drag the sheet while holding down the Ctrl key,. The sheet is now copied.
3. Copy as many sheets as needed, change the PivotTable structure in each sheet, and add a different Chart to each PivotTable report.

Note:
Refreshing one PivotTable report refreshes each of the additional PivotTable reports, as they all use the same source data stored in the cache memory.