Move a Pivot Chart to Another Sheet in Excel

In Excel for Microsoft 365 on Windows, select the PivotChart, choose Chart Design > Move Chart, select Object in, choose the destination worksheet, and click OK. This moves the chart, not its PivotTable, so the chart remains connected to the PivotTable and its source data.

What moving a PivotChart actually does

A PivotChart is a chart linked to a PivotTable. Its fields, filters, and displayed values come from that PivotTable rather than from a separate set of ordinary chart data references. Moving the chart to another worksheet changes where it is displayed; it does not relocate the PivotTable or change the underlying source data.

This distinction matters when organizing a workbook. For example, a worksheet called Data might contain a PivotTable summarizing monthly sales, while a worksheet called Dashboard contains the chart. You can put the chart on Dashboard and leave the PivotTable on Data. The chart can still be refreshed and its PivotChart fields can still be used because the connection remains in the workbook.

Moving the chart is also different from copying it. A move removes the chart from its original location and places it on the destination sheet. A copy creates another chart object; because PivotCharts are connected to PivotTable data, copied charts may share the same PivotTable connection and interact with the same report filters. If you need independent analysis, create a separate PivotTable and PivotChart rather than assuming a copied chart is independent.

Move the chart with the Move Chart command

Use this method when you know which worksheet should hold the chart. First make sure the destination worksheet already exists. Then:

Click the PivotChart’s outer border so the whole chart is selected. Clicking a bar, line, legend, or field button may select a chart element instead.
On the ribbon, open Chart Design. The tab appears when a chart is selected.
Choose Move Chart.
In the dialog, select Object in, then choose the destination worksheet from the list.
Click OK. Excel places the chart on that worksheet as an embedded object.

After the move, use the worksheet tabs to confirm that the chart is on the intended sheet. If you chose the wrong destination, repeat the command and select another worksheet. The command moves the chart object; it does not create a new worksheet or move the PivotTable for you.

On Excel for Mac, select the chart and look for Move Chart on the Chart Design tab. Ribbon placement can vary slightly by version and window width. The same principle applies: select an existing worksheet as the destination. Excel for the web has a more limited chart-editing interface, so if the command is not available there, open the workbook in the desktop app to move the chart.

Move it by cutting and pasting

Cut and paste is a practical alternative if you already have the destination worksheet open or the Move Chart dialog is inconvenient. Select the chart’s outer border, press Ctrl+X on Windows, click the destination worksheet tab, and press Ctrl+V. On a Mac, use Command+X and Command+V.

Make sure the chart itself is selected before cutting. If a single data point or chart element is selected, the result may not be the whole chart you intended to move. After pasting, click an empty cell to leave chart-editing mode and check that the chart is positioned correctly. Cut and paste should preserve the PivotChart connection when moving within the same workbook, but the Move Chart command makes the destination choice more explicit.

If the chart is difficult to select because it overlaps other objects, use the selection controls on the worksheet or temporarily move nearby objects. Avoid deleting the original chart until you have confirmed the pasted chart appears and responds as expected. Save the workbook after the move, especially if it is a shared or complex reporting file.

Keep the PivotTable and chart easy to maintain

A common dashboard layout puts a PivotTable on a supporting worksheet and its PivotChart on a presentation worksheet. The PivotTable can remain visible for checking the summarized numbers, or the supporting sheet can be hidden after the report is complete. Hiding a worksheet does not itself break a PivotChart, but workbook users may find it harder to inspect or adjust the PivotTable if they do not know where it is.

Give the two sheets clear names, such as Sales Pivot and Sales Dashboard. You can rename a sheet by double-clicking its tab and entering a new name. If the workbook contains several PivotTables, make a note of which one supplies each chart. This is especially useful when the charts have similar titles or when a dashboard has been assembled over time.

When you refresh the PivotTable, the PivotChart reflects the updated PivotTable results. To refresh, right-click a cell in the PivotTable and choose Refresh, or use Data > Refresh All to refresh workbook connections and reports together. If the chart does not show expected values, check the PivotTable and its filters before assuming the move caused a problem.

PivotChart field buttons can take up space on a dashboard. Select the chart and use PivotChart Analyze > Field Buttons > Hide All to hide them, if that command is available in your ribbon layout. Hiding these buttons changes what is displayed on the chart, not the underlying PivotTable or its connection. Users who need to change the report filters may prefer to keep the buttons visible or use slicers connected to the PivotTable.

Choose an ordinary worksheet, not a chart sheet

The Move Chart dialog can offer a New sheet option. That option creates a dedicated chart sheet: a sheet designed to display a chart rather than a normal grid of worksheet cells. It is not the same as moving a chart onto a new worksheet. PivotCharts are intended to remain associated with their PivotTable and are not supported on chart sheets, so use Object in and select an existing worksheet for a PivotChart.

If you want a clean page for presenting the chart, create a normal worksheet, give it a descriptive name, and move the PivotChart there. You can then resize the chart, adjust its placement, and add titles or other worksheet content. A normal worksheet gives you room for notes, slicers, labels, and additional charts while preserving the PivotChart’s relationship with its PivotTable.

For a chart sheet specifically, consider whether a regular chart based on a prepared range is more suitable. That is a different chart setup: it may not have the same direct PivotChart field controls or behavior. Choose it only if you do not need the chart to function as a PivotChart connected to the PivotTable.

What to check after moving it

A quick check can catch most layout or connection issues. Confirm that the chart appears on the intended worksheet, that its title and labels are readable, and that it displays the expected values. If the chart has field buttons or slicers, test the controls that readers will use. A moved chart can be partly off-screen or overlap cells and other objects, so adjust its size and position on the destination sheet.

Check filters: Look at the PivotTable’s report filters and the PivotChart’s field buttons. A filter may make the chart look empty or incomplete even though the move succeeded.
Check the source report: Find the associated PivotTable and confirm that its values match the chart’s summary.
Check slicers: If slicers are present, verify that they still control the expected PivotTable and chart. Slicer connections depend on the PivotTable relationship, not simply on which sheet displays the chart.
Check layout: Resize the chart and leave enough room for labels, legends, and any interactive controls. Consider viewing the sheet at the zoom level readers will use.
Check printing: If the dashboard is intended for print or PDF, use print preview to verify that the chart fits the selected print area and page orientation.

Moving a chart between worksheets in the same workbook should not require changing the PivotTable’s source range. If the source data is later expanded, the PivotTable may need its source range updated or the data may need to be stored in an Excel table so new rows are included as intended. That is a data-source maintenance issue, not a consequence of where the chart is displayed.

Common problems and what they mean

Move Chart is missing or unavailable. Click the chart’s border to select the chart object, rather than a cell or an individual chart element. Then check the Chart Design tab. If the workbook is open in Excel for the web, use the desktop version if the required chart command is not offered.

The chart is on the right sheet but seems unchanged. That is normal: moving it does not change the PivotTable’s filters, field arrangement, or source data. To change what the chart shows, use its PivotChart field buttons, slicers, or the associated PivotTable controls.

The chart changes when another report is filtered. PivotCharts connected to the same PivotTable can respond to that report’s filters. A copied chart is not necessarily an independent report. If separate filter behavior is essential, build a separate PivotTable and create a chart from that report.

The destination sheet does not appear in the list. Confirm that it exists in the same workbook and is available for editing. Create or unhide the worksheet, then try the Move Chart command again. The command does not move a chart directly into a different workbook; for a cross-workbook transfer, copy or cut and paste, then verify the chart’s data connection and behavior in the destination file.

Frequently Asked Questions

Can I move a PivotChart without moving its PivotTable?
Yes. Use Chart Design > Move Chart > Object in and select the destination worksheet. The PivotTable stays where it is, and the chart remains linked to it.

Will moving a PivotChart break its connection?
Moving it to another worksheet in the same workbook does not normally break its PivotTable connection. Check the chart and refresh the PivotTable afterward if the displayed results appear out of date.

Can I move a PivotChart to a new chart sheet?
A chart sheet is different from a worksheet, and PivotCharts are not supported on chart sheets. Move the chart to an existing worksheet, or create a regular chart if a dedicated chart sheet is essential.

Can I put the PivotChart on a different worksheet from its PivotTable?
Yes. Keeping the PivotTable on a data or support sheet and the chart on a dashboard worksheet is a common arrangement. Use clear sheet names so the report’s source is easy to find.

Can I move the PivotTable and PivotChart together?
The Move Chart command moves only the chart. Move or cut and paste the PivotTable separately if you also want to relocate it, then check that the chart still displays the expected report.

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.