'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Charts Not Copied When Moving or Copying a Worksheet
Question details
Users experience an issue where embedded charts fail to transfer when attempting to duplicate, move, or copy a worksheet to a new or existing workbook.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Using the 'Move or Copy' command on a worksheet tab to duplicate a sheet containing data and charts.
- Observed behavior
- The worksheet's cell data and formatting are successfully duplicated, but the charts are entirely missing from the new sheet.
Ensure your workbook is not protected, as structure protection can prevent objects like charts from being copied. You should also check the chart properties by right-clicking the chart, selecting 'Format Chart Area', and ensuring 'Move and size with cells' is enabled.
Manually Copy Charts and Update Source References
If the built-in Move or Copy sheet command fails to transfer objects, manually copying the charts and relinking their data sources is the most reliable workaround.
This method ensures that the visual elements are transferred successfully, though it requires a manual update of the data formulas so the new charts pull data from the new worksheet instead of the original one.
Right-click the original sheet tab and use the 'Move or Copy' command to duplicate the cell data to your desired location.
Return to the original worksheet, select the chart or hold down Ctrl to select multiple charts, and press Ctrl+C to copy them.
Navigate to the newly copied worksheet, click a blank cell where you want the charts to appear, and press Ctrl+V to paste.
Click the pasted chart, go to the 'Chart Design' tab on the ribbon, and click 'Select Data'. Edit the 'Chart data range' to replace the old sheet name with the new sheet's name.
Highlight and Copy the Entire Worksheet Area
Instead of using the sheet tab's right-click menu, selecting the specific cell range that encompasses both the data and charts can force Excel to copy everything together.
Repair Microsoft 365 Installation
If charts consistently fail to copy across all workbooks, your Office installation might be experiencing a software glitch that requires a repair.
Try WPS Office to Manage Worksheets and Charts Flawlessly
Experiencing glitches with Excel's move or copy sheet features? WPS Office provides a seamless, lightweight, and highly compatible alternative that perfectly preserves your charts, tables, and formatting when duplicating worksheets.
- 1. Install WPS Office: Download and install the free WPS Office suite on your device.
- 2. Open your workbook: Launch WPS Spreadsheet and open your existing .xlsx file without losing any formatting.
- 3. Copy the worksheet: Right-click the sheet tab and select 'Move or Copy' to seamlessly duplicate your data and charts.
Frequently Asked Questions
Why do charts disappear when duplicating a tab in Excel?
This often occurs due to hidden structural protections in the workbook, software glitches within Microsoft 365, or the chart properties being set to 'Don't move or size with cells', which prevents them from transferring.
Can I copy multiple Excel charts at once to a new worksheet?
Yes, you can hold down the Ctrl key and click each chart to select multiple objects simultaneously. Then press Ctrl+C, navigate to the new worksheet, and press Ctrl+V to paste them all together.
How do I easily update the formula for a copied chart?
Click on the data series line or bars inside the copied chart to reveal its formula in the top formula bar. Manually change the worksheet name reference (e.g., changing 'Sheet1' to 'Sheet2') and press Enter to instantly update the data source.
