Link a PivotChart to a Different PivotTable in Excel

You generally cannot retarget an existing Excel PivotChart directly to a different PivotTable. To make a chart use another PivotTable, create a new PivotChart from that table; if you only need a different view of the same data, adjust the PivotChart’s associated PivotTable instead.

Why a PivotChart stays connected to its PivotTable

A PivotChart is not an ordinary chart whose series can be freely pointed at any worksheet range. It is an interactive chart attached to a PivotTable, and its field buttons, filters, and layout are driven by that table. This connection is what lets you change a category or filter and have the chart update with the PivotTable.

Consequently, Excel does not provide the ordinary chart workflow of selecting a chart and choosing a new range through Select Data. In a PivotChart, that command is unavailable or restricted because the chart reads the summarized data and field arrangement from its associated PivotTable. Changing the data source of that PivotTable is different from switching the chart to a separate PivotTable.

This distinction matters even when two PivotTables look identical. One might summarize the same sales records by month and region, while another uses a different source, cache, or field arrangement. Excel treats them as separate PivotTable reports, not simply as interchangeable chart ranges.

Create a replacement PivotChart from the other table

In Excel for Microsoft 365 on Windows, use the target PivotTable to create a new chart:

Click a cell inside the PivotTable you want the chart to represent.
Open PivotTable Analyze > PivotChart. In some ribbon layouts, the PivotChart command is in the Tools group.
Choose a chart type and select OK.
Position and resize the new chart, then set its fields and filters to match the view you need.
Copy visual formatting from the old chart where useful, and then remove or keep the old chart as appropriate.

Another route is to select a cell in the target PivotTable and use Insert > PivotChart. Ribbon labels and placement can vary slightly with Excel updates and window size. In Excel for Mac, select the target PivotTable and use the PivotChart command on the ribbon, commonly under Insert; the exact tab layout may differ from Windows. Excel for the web has fewer editing capabilities than the desktop app, so use desktop Excel if the PivotChart command or required formatting controls are unavailable.

This creates a chart connected to the selected table; it does not convert the original chart. If you need to preserve a carefully formatted chart, record its chart type, colors, titles, and size before replacing it. Copying and pasting a chart may preserve some formatting, but it does not reliably transfer the chart’s PivotTable connection. Confirm the new chart responds to the target table’s filters before deleting the original.

Change the existing PivotTable instead

If your goal is a different chart result rather than a different PivotTable object, it may be simpler to keep the existing connection. Click in the PivotTable associated with the chart and rearrange its fields in the PivotTable Fields pane. For example, move Month from Rows to Columns, add Region to Filters, or replace Sum of Sales with another value field. The PivotChart updates to reflect those changes.

Be aware that changes to the associated PivotTable can change the chart’s categories, series, totals, or filter state. A chart that originally showed monthly sales by region may become a chart of annual totals if you group dates or remove fields. This is still the same connected report, not a chart linked to another PivotTable.

If you need both views at once, retain the original PivotTable and chart, then create a second PivotChart from the other PivotTable. Give each report a clear title and, if practical, place them on separate sheets or in clearly labeled areas. That is usually easier to maintain than trying to force one PivotChart to represent two independent reports.

What PivotTable caches and shared data mean

PivotTables built from the same source data may share a PivotCache, Excel’s stored representation of the source used for summarizing and filtering. Sharing a cache can help reduce workbook size and can allow related reports to use common slicers or timelines. It does not mean that their PivotCharts automatically become one chart or that you can freely attach a chart to any report using that cache.

For example, imagine two PivotTables based on the same sales list. One shows sales by salesperson and the other shows sales by product. A slicer connected to both reports may filter both, if their data source and cache support that connection. But a PivotChart created from the salesperson report remains associated with that report. To chart the product report, create a PivotChart from the product PivotTable.

When PivotTables come from different sources or use different caches, shared filtering may not be available. The Data Model and certain external data connections also have their own compatibility and connection requirements. If a slicer’s Report Connections list does not include a PivotTable, check whether the reports share a compatible source and cache; the missing connection is not proof that the chart can be retargeted instead.

Use a regular chart when you need range-level control

A normal chart can be based on a selected range of cells, including a PivotTable’s visible output. If you want a chart that can be pointed to a different range through Chart Design > Select Data, create a standard chart from an appropriate range rather than a PivotChart. You can often create one by selecting the summarized cells and using Insert to choose a chart type.

The trade-off is interactivity. A regular chart does not expose PivotChart field buttons or automatically behave as a PivotTable report. It may reflect cell changes in its source range, but it does not become a PivotChart just because its source cells happen to be PivotTable results. Changes in the PivotTable’s shape—such as adding a field or changing the layout—can also make a range-based chart include the wrong cells or omit new ones.

Use a PivotChart when you want chart fields and report filters to follow a PivotTable. Use a standard chart when you want more control over chart series and source ranges, or when the chart should combine values that do not belong to one PivotTable report. Check the selected source range and chart behavior after changing the PivotTable layout.

Common problems when replacing or connecting charts

The chart does not change when you edit the other PivotTable. That is expected if the chart remains connected to its original table. Create a new PivotChart from the intended table.
Select Data is unavailable. You are likely working with a PivotChart. Use its associated PivotTable to change the view, or create a standard chart from a range if range-based series selection is required.
A slicer filters one report but not another. Check the slicer’s Report Connections or PivotTable Connections options. Reports generally need compatible underlying data and cache arrangements to share slicer control.
The new chart has the wrong fields or appearance. A new PivotChart reflects the target PivotTable’s layout, not necessarily the old chart’s layout. Set the target table’s fields, then configure the chart type, title, labels, and formatting.
The chart changes after a refresh. Refreshing can update the PivotTable’s summarized results and therefore its chart. If the chart’s source table or data connection is not the one you intended, verify the PivotTable before refreshing or sharing the workbook.

A practical choice for a two-report example

Suppose a workbook has a first PivotTable showing quarterly revenue by sales territory and a second showing revenue by product category. The existing PivotChart is attached to the territory report, but you now need a product chart for a presentation. If you edit the territory PivotTable, the chart will follow that report’s revised fields; it will not switch to the product report. Instead, click inside the product PivotTable and insert a PivotChart. Keep both reports if the presentation needs both perspectives.

If the desired product chart needs a custom selection of cells, a combined metric from separate summaries, or a fixed layout that should not change with PivotTable fields, consider a standard chart. That choice gives you more direct range control, but you must maintain its source range and confirm it still represents the intended data after refreshes and layout changes.

Frequently Asked Questions

Can I change a PivotChart’s PivotTable from the chart itself?
Not as a direct reassignment to another existing PivotTable. Create a new PivotChart from the desired PivotTable, or change the fields in the PivotTable already associated with the chart.

Can two PivotCharts use the same PivotTable?
Yes. You can create more than one chart from a PivotTable. Their presentation and chart formatting can differ, while their report data and field arrangement are governed by the connected PivotTable. Changes to that table can affect both charts.

Can one slicer control PivotCharts from different PivotTables?
Sometimes. The reports generally need compatible sources and a shared PivotCache or otherwise compatible model connection. Use the slicer’s report-connection settings to see which PivotTables Excel allows you to connect.

Can I keep my old chart’s formatting when I make the new one?
You can reproduce or copy formatting, but copying the chart does not guarantee a new PivotTable connection. Create the replacement from the target PivotTable first, then check its fields, chart type, and formatting.

Is a chart based on PivotTable cells a PivotChart?
No. A standard chart can use PivotTable output as its source range, but it remains a regular chart. It has range-based chart controls rather than PivotChart field controls, and changes to the PivotTable layout may affect which cells it charts.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.