'%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)
Fix Excel Move Chart to New Worksheet Not Working After Update
Question details
The Move Chart to New Worksheet feature in Excel fails to function properly after a recent software update.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to move an existing chart to a dedicated chart sheet in Microsoft 365 version 2301.
- Observed behavior
- The chart does not move correctly, displaying only a small icon instead of scaling. Additionally, previously created chart sheets in existing files fail to render correctly.
Verify your current Microsoft 365 version by navigating to File > Account > About Excel, and ensure all active workbooks are completely closed before running any installation diagnostic tools.
Perform an Online Repair of Microsoft 365
Using the built-in Office Repair tool resolves corrupted installation files and rendering engine glitches caused by the version 2301 update.
Since this issue is tied specifically to the Microsoft 365 version 2301 update, the application files may have been corrupted or improperly configured during the update process. Running an Online Repair replaces all application files and is the most effective way to restore chart rendering capabilities.
Click the Start menu, type 'Control Panel', and press Enter. Navigate to 'Programs' and then click on 'Programs and Features'.
Scroll through the list of installed programs until you find 'Microsoft 365' or your specific version of Microsoft Office.
Right-click the Microsoft 365 application and select 'Change' or 'Modify' from the context menu. Allow the app to make changes to your device if prompted.
In the dialog box that appears, select 'Online Repair' (highly recommended over Quick Repair for comprehensive fixes) and click the 'Repair' button.
Follow the on-screen prompts to complete the repair. Once finished, restart your computer, open Excel, and try moving a chart to a new worksheet again.
Create a Brand New Chart as a Workaround
A temporary workaround if repairing does not immediately fix the rendering of older charts in existing workbooks.
Try WPS Office for Flawless Charting and Data Visualization
If Microsoft Excel continues to experience rendering bugs after recent updates, consider switching to WPS Office. WPS Spreadsheet offers a highly compatible, lightweight, and completely free alternative for managing complex data, creating dynamic charts, and seamlessly moving them across worksheets without display errors.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing .xlsx workbook directly.
- 2. Create or select your chart: Highlight your data and insert a new chart, or select an existing one.
- 3. Move the chart seamlessly: Right-click the chart, choose 'Move Chart', and select a new worksheet to display it flawlessly.
Frequently Asked Questions
Why did the Move Chart feature stop working in Excel version 2301?
The Microsoft 365 version 2301 update introduced a bug affecting the rendering engine for dedicated chart sheets. This glitch causes charts moved to new sheets to appear as tiny icons or fail to load entirely, which was not present in the previous version 2212.
Will a Quick Repair fix the Excel chart rendering issue?
A Quick Repair only replaces missing or corrupted files locally, which is often not enough to resolve version-specific update bugs. An Online Repair is highly recommended because it completely reinstalls and refreshes the application files from Microsoft's servers.
Can I just cut and paste the chart to a new sheet as a workaround?
While you can manually cut a chart and paste it into a standard worksheet cell, it does not behave exactly like a dedicated Chart Sheet. A Chart Sheet optimizes the layout for scaling, viewing, and printing the chart exclusively without cell gridlines.
