Chart & Visualization Issues

How to Copy an Excel Worksheet and Chart Without Recreating References

Steve K Oct 13, 2026 869 views

Question details

The user wants to duplicate a worksheet containing a chart so that the new chart references the data on the duplicated sheet, not the original sheet.

How to Copy an Excel Worksheet and Chart Without Recreating References

Product: Excel
Device & OS: not provided
Scenario: Duplicating a worksheet with formulas, formatting, and charts for independent use.
Observed behavior: Standard copy-pasting content to a new sheet leaves the copied chart referencing the original worksheet's data instead of the new one.

Before you start

Ensure your Excel workbook is saved and check that the chart on your current worksheet correctly references the data within the same sheet before duplicating.

Solution 1Recommended

Duplicate the Worksheet Using the Ctrl + Drag Method

This is the fastest and most reliable way to duplicate a worksheet along with its charts, ensuring the new chart references the new sheet's data.

Instead of copying and pasting the cells and chart manually, you can clone the entire worksheet. When a worksheet is cloned, Excel automatically updates the chart's data source to reference the newly created sheet.

Select the worksheet tab

Click and hold the left mouse button on the worksheet tab you want to copy at the bottom of the Excel window.

Hold the Ctrl key

Press and hold the 'Ctrl' key on your keyboard. You will see a small plus sign (+) appear on the cursor icon indicating a copy action.

Drag to duplicate

While holding both the mouse button and the Ctrl key, drag the worksheet tab to the left or right to place the new sheet.

Release to confirm

Release the mouse button first, and then release the Ctrl key. A complete copy of the worksheet will be created, and the duplicated chart will correctly reference the new sheet's data.

Duplicate the Worksheet Using the Ctrl + Drag Method

Verification: Click on the duplicated chart and check its data source to confirm it now references the new worksheet instead of the original one.

Easy Spreadsheet Management

Copy Worksheets and Charts Effortlessly in WPS Spreadsheet

WPS Spreadsheet allows you to duplicate complex worksheets, including data formatting, formulas, and charts, with just a few clicks. The duplicated charts will automatically reference the data in the newly created sheet.

1. Open your file in WPS: Launch WPS Office and open your spreadsheet document containing the chart.
2. Right-click the sheet tab: Right-click the worksheet tab at the bottom of the screen and select 'Move or Copy'.
3. Create a copy: Check the box that says 'Create a copy', choose where you want to place the duplicated sheet in your workbook, and click 'OK'.
4. Check chart references: The worksheet is now duplicated, and your charts will automatically pull data from the newly copied sheet without linking back to the original.

Fully compatible with Microsoft Excel (.xlsx, .xls) files and chart formats.Duplicate entire worksheets and charts instantly without broken references.Lightweight software with a familiar, easy-to-navigate tabbed interface.Free to use for everyday data analysis and visualization.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my copied chart still link to the old worksheet?

This happens if you simply copy the chart object and paste it into a new sheet. Excel retains the absolute reference to the original sheet's data source. Duplicating the entire worksheet tab instead resolves this issue.

Can I use the 'Move or Copy' menu instead of dragging?

Yes. Right-click the worksheet tab, select 'Move or Copy...', check the 'Create a copy' box, and click OK. This achieves the exact same result as the Ctrl + Drag method.

How do I copy multiple worksheets with charts at once?

Hold the Ctrl key (or Shift for continuous sheets) to select multiple worksheet tabs at the bottom. Once all desired tabs are highlighted, use the Ctrl + Drag method or the 'Move or Copy' menu to duplicate them all simultaneously.

Excel & Data Problems