How to Remove an Unexpected Chart Sheet from an Excel Workbook in WPS Office
Question details
The user needs to locate and delete an extra chart sheet that appears unexpectedly in an Excel workbook or email attachment.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user opens an Excel workbook or email attachment and notices an extra chart sheet that was not intentionally created.
- Observed behavior
- An unwanted chart sheet appears as a separate tab, or an unwanted chart object appears on a worksheet.
Open the workbook in WPS Office Spreadsheets and make sure the sheet tabs are visible at the bottom of the window. If the file is an email attachment, save it locally first so the deletion can be saved.
Delete an Unexpected Standalone Chart Sheet
Use this when the unexpected chart appears as its own sheet tab in the workbook.
A chart sheet is a separate sheet that contains only a chart. Deleting it does not remove the source data from other worksheets.
Click Menu > Open and select the workbook or the saved email attachment.
Look at the sheet tabs at the bottom of the window and click the tab that shows the unwanted chart.
Right-click the chart sheet tab and choose Delete from the context menu.
Click OK or Yes when prompted to permanently remove the chart sheet.
Press Ctrl+S or click Menu > Save to save the workbook after the chart sheet is removed.
Delete a Chart Object Embedded on a Worksheet
Use this when the unwanted chart floats on a normal worksheet instead of appearing as its own tab.
Remove Unwanted Chart Sheets with WPS Office Spreadsheets
Open the Excel workbook in WPS Office Spreadsheets, right-click the unexpected chart sheet tab or select the floating chart object, delete it, and save the file. WPS preserves the original workbook format so the cleaned file remains compatible with Microsoft Excel.
- 1. Open the workbook: Click Menu > Open and select the Excel workbook or saved email attachment.
- 2. Select the unwanted chart sheet tab: Click the chart sheet tab at the bottom of the WPS Office Spreadsheets window.
- 3. Delete the chart sheet: Right-click the tab and choose Delete, then confirm the removal.
- 4. Remove an embedded chart if needed: If the chart floats on a worksheet, select the chart border and press Delete.
- 5. Save the cleaned workbook: Press Ctrl+S or click Menu > Save to keep the removed chart sheet or chart.
Frequently Asked Questions
How do I tell if the unexpected chart is a chart sheet or an embedded chart?
Check the sheet tab bar. A chart sheet has its own tab and contains only the chart, while an embedded chart floats on a worksheet and shows normal cell data behind it.
Why did a chart sheet appear even though I did not create it?
A chart sheet can be created unintentionally by pressing F11, by using the Move Chart option and choosing New sheet, or by opening a workbook shared by someone else.
Will deleting the chart sheet remove my worksheet data?
No. A standalone chart sheet only contains the chart view. The source data remains on its original worksheet unless that worksheet is also deleted.
What should I do if Delete is grayed out on the chart sheet tab?
Check whether the workbook is protected or shared. Use Review > Protect Workbook or Share Workbook to review restrictions, or save a copy and remove the chart from the copy.
Can I remove the chart from an email attachment without changing the original file?
Yes. Save the attachment locally, open it in WPS Office Spreadsheets, delete the chart, save as a new file, and use the saved copy for further sharing.
