Duplicate Pivot Charts and Tables in Excel

To duplicate a PivotTable in Excel for Microsoft 365 on Windows, select the whole table with PivotTable Analyze > Select > Entire PivotTable, press Ctrl+C, choose an empty destination, and press Ctrl+V. To duplicate its PivotChart, select the chart’s outer border and copy and paste it; for a chart with independent PivotChart filters, duplicate the PivotTable first and insert a new chart from that copy.

What copying a PivotTable or PivotChart actually does

A PivotTable is a report built from source data, while a PivotChart is a chart connected to a PivotTable. Copying a PivotTable makes another report layout in the workbook. Copying a PivotChart makes another chart object, but it remains connected to the same PivotTable as the original. That difference matters when you want two views that can be filtered or rearranged separately.

Copied PivotTables in the same workbook generally use the same PivotCache: Excel’s stored, processed copy of the source data. They can still have separate field arrangements and report filters. Sharing a cache does not mean that changing a filter on one table automatically filters the other. But sharing can affect features such as grouping, and it does not give the copy a separate underlying data source. A copied chart, by contrast, continues to use its original PivotTable’s fields and filters.

How to duplicate a PivotTable step by step

Click a cell inside the PivotTable you want to copy.
On the ribbon, choose PivotTable Analyze > Select > Entire PivotTable. Check that the complete report, including its row and column labels, is selected.
Press Ctrl+C. Select a blank cell far enough away to leave room for the copied table, or go to a blank worksheet and select its destination cell.
Press Ctrl+V. Excel pastes a second PivotTable, which you can rearrange without changing the first table’s field layout.
Click the new table and, if useful, change its name in the PivotTable Name box on the PivotTable Analyze tab. Use a distinct name such as SalesByMonth and SalesByRegion.

Leave enough empty cells around the destination. PivotTables can expand when you add fields or refresh, and they cannot overlap another PivotTable or occupied cells in the area where they need to grow. If Excel reports that it cannot complete the operation because a PivotTable would overlap another one, move the copy to a clear area or a separate worksheet.

On a Mac, the equivalent copy-and-paste keys are usually Command+C and Command+V; ribbon labels can vary slightly by Excel version. In Excel for the web, copying and pasting is also available, but ribbon options and behavior may differ from the Windows desktop app. The steps above describe Microsoft 365 for Windows.

How to duplicate a PivotChart

To make another copy of an existing PivotChart, click its outer edge so the chart object is selected, then press Ctrl+C, click the destination, and press Ctrl+V. If a chart element such as a title or legend is selected instead, click the outside border first so you copy the entire chart. Drag the pasted chart into position or resize it using its corner handles.

The copy keeps the chart type, formatting, field buttons, and connection to the same PivotTable. That is convenient when you want a second visual with the same data and filter behavior—for example, a copy on a dashboard sheet. However, changing a field filter on one of two charts based on the same PivotTable also changes what the other chart displays, because both charts show that PivotTable’s current view.

To create a separate PivotChart, select the duplicated PivotTable and choose PivotTable Analyze > PivotChart, then choose a chart type. This makes the new chart use the copied table. It can then reflect that table’s field layout and report filters rather than the original table’s view. You can move it to another worksheet with Chart Design > Move Chart, if needed.

Make the table and chart filters independent

Start by duplicating the PivotTable, then insert a PivotChart from the duplicate. For example, imagine a sales PivotTable with Region in Rows, Month in Columns, and Revenue in Values. Keep the first table arranged by region, then arrange the second one by month and product. Create a chart from the second table. The two reports can present different layouts, and their individual report filters can show different selections.

There is an important distinction between report filters and slicers. A slicer can control multiple PivotTables when those tables are compatible and connected to the slicer. Select the slicer and use the Slicer tab’s Report Connections or PivotTable Connections command (the label depends on the Excel build) to choose which tables it controls. If both tables are connected, clicking a slicer item filters both; clear or change those connections when you need separate slicer behavior.

Because copied PivotTables commonly share a cache, duplicating is not the same as creating a wholly separate data model. If a requirement depends on isolated grouping or source data, create a separate PivotTable from an appropriate separate source or model and confirm how Excel handles its cache. For ordinary dashboard layouts, a copied table plus a chart inserted from that copy is usually the practical way to create a separately arranged view.

Keep duplicate reports current when source data changes

A pasted PivotTable does not necessarily include new source rows merely because the worksheet data has grown. If the source is an Excel Table, add records within that Table so its range expands, then refresh the report. To refresh one PivotTable, click inside it and choose PivotTable Analyze > Refresh. To refresh workbook connections and reports together, use Data > Refresh All.

If the source range itself has changed, select the PivotTable and use PivotTable Analyze > Change Data Source to check or update it. A copied table that shares the original cache may be refreshed from the same source data; refresh results can therefore update other PivotTables using that cache too. If you are sending a workbook to someone else, verify that the source is still available and that the recipient can refresh any external connection.

After refreshing, check both the copied table and its chart. A PivotChart reflects its connected PivotTable, so it should display the refreshed report once the table is current. If the chart appears unchanged, confirm that you refreshed the correct source and that the chart is connected to the table you intended.

Common copy problems and how to fix them

Only part of the table copied: select PivotTable Analyze > Select > Entire PivotTable before copying, rather than selecting a few visible cells.
Excel says the destination is occupied: choose a larger empty area or a new worksheet. A PivotTable needs room to expand, not just enough room for its current size.
The second chart changes when the first is filtered: both charts are attached to the same PivotTable. Create a second PivotTable and insert a chart from it for a separate view.
A slicer filters both reports: inspect the slicer’s report or PivotTable connections and disconnect the report that should not respond.
The copy does not show added records: check the PivotTable’s data source, then refresh. Consider using an Excel Table as the source so newly added rows are included in its expanding range.
A workbook gets larger than expected: remember that PivotTables can hold cached source data. Many copies or separate caches can increase workbook size; avoid creating extra reports that are not needed.

Choose the right duplication method

Use a copied PivotTable when you need another layout, another report filter, or a base for a separate PivotChart. Use a copied PivotChart when you want another visual of the same PivotTable view—for instance, a duplicate placed on a presentation sheet. If you want a chart that does not behave like a PivotChart, make a regular chart from a separate range of values instead. A regular chart is not controlled by PivotChart field buttons, and its source range must be maintained appropriately as the report changes.

For a dashboard, a useful arrangement is one PivotTable for each distinct analytical view, with a PivotChart created from the table it represents. Give tables clear names, keep them on a dedicated report sheet if that helps organize the workbook, and connect shared slicers only when you intentionally want one selection to control multiple reports.

Frequently Asked Questions

Can I copy a PivotTable to another worksheet?

Yes. Select the entire PivotTable, copy it, open the destination worksheet, and paste into a blank area. The pasted report remains a PivotTable; make sure its source data is still available in the workbook and leave space for it to expand.

Will duplicating a PivotTable change the original?

Changing the copied table’s field layout or its own report filter normally does not change the original table’s layout or filter. But the tables commonly share a PivotCache, and slicers or cache-dependent features can create linked behavior. Check slicer connections if both tables respond to one control.

Can two copied PivotCharts have different filters?

Not if both charts are copies linked to the same PivotTable: they show that table’s filtered view. To give them separate PivotChart views, duplicate the PivotTable and insert a new chart from the duplicate.

How do I duplicate a PivotChart without losing its formatting?

Select its outer border and copy and paste it. The new chart retains the original formatting and PivotTable connection. If you instead create a new PivotChart, you may need to apply or adjust formatting to match the first chart.

Does Refresh All update duplicated PivotTables?

Data > Refresh All refreshes workbook data connections and PivotTables. Reports that share a cache use the same cached source data, but check each report after refreshing, especially when sources or connection settings differ.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.