The fastest way to remove a chart
Click the chart once to select it, then press Delete. That's it — the chart disappears and the spreadsheet data underneath stays intact. If you accidentally delete a chart, press Ctrl+Z (or Cmd+Z on Mac) when ready to undo.
The chart itself is a separate object sitting on top of your spreadsheet, not part of the data. Deleting it removes only the visual — all your numbers remain in their cells exactly as they were. This is why you can safely delete a chart without worrying about losing information.
On a Mac, the process is identical except you use Cmd+Z instead of Ctrl+Z for undo. The Delete key works the same way on both Windows and Mac keyboards.
Key Takeaways
- Select a chart by clicking it once, then press Delete to remove it completely.
- Deleting a chart does not affect any of the data in your spreadsheet cells.
- If you delete a chart by mistake, press Ctrl+Z (or Cmd+Z on Mac) to undo the deletion when ready.
- You can also right-click a chart and choose Delete from the menu if the Delete key does not work.
- Charts on protected sheets cannot be deleted unless the sheet is first unprotected with a password.
Why the chart might not be selected
If you click a chart and nothing happens when you press Delete, you probably clicked inside the chart rather than on it. When you click inside, Excel enters edit mode — you are now editing the chart itself, not selecting it as an object. In edit mode, the chart has a gray border and you can change titles, colors, and axis labels.
To exit edit mode and select the whole chart, click the white space around the chart's border, or press Escape. Then click the chart once more. You should see a border with small squares at the corners and edges. That border means the chart is selected as an object and ready to delete. The squares are called selection handles, and they appear only when the chart is selected as a whole object rather than in edit mode.
Deleting a chart using the right-click menu
If the Delete key does not work on your keyboard, right-click the chart and look for a "Delete" option in the menu that appears. Click it, and the chart is removed. This menu also shows other options like "Cut" (which removes the chart but saves it to paste elsewhere) and "Copy" (which duplicates the chart).
This method works the same way as pressing Delete — it removes only the chart, not the data. The right-click menu is useful if your Delete key is broken or if you prefer using the mouse. Make sure the chart is selected as a whole object before right-clicking, not in edit mode.
What happens to your data after you delete a chart
Your spreadsheet data is completely unaffected. Every number, formula, and cell reference stays exactly where it was. The chart is only a visual representation of that data — removing the picture does not change the underlying numbers. If the chart was based on cells A1 through A10, those cells will still contain the same values after the chart is gone.
If you later decide you want a chart again, you can create a new one from the same data using the Insert menu. The data will be waiting for you unchanged. You can even create a different type of chart — a bar chart instead of a line chart, for example — using the exact same cells.
Undoing a deletion if you change your mind
If you delete a chart and then realize you wanted to keep it, press Ctrl+Z (Windows) or Cmd+Z (Mac) right away. Excel will restore the chart to its exact position with all its formatting intact. The chart will reappear exactly where it was, with the same colors, labels, and data range.
This undo works only if you have not made other changes since the deletion. If you have already made several edits, the undo may restore an earlier version of your spreadsheet instead. For this reason, undo when ready after deleting if you are unsure. You can press Ctrl+Z multiple times to step back through your recent actions one at a time.
Removing a chart from a protected sheet
If your spreadsheet is password-protected, you may not be able to delete a chart. Excel allows the sheet owner to lock down which objects can be edited or removed. If you try to delete a chart and get an error message saying the sheet is protected, you will need the password to unprotect it first.
Ask the person who created or shared the spreadsheet for the password. Once the sheet is unprotected, you can delete the chart normally. You can then re-protect the sheet if needed by going to the Review tab and selecting "Protect Sheet." The protection settings may allow charts to be deleted while protecting the data cells themselves.
Frequently Asked Questions
Does deleting a chart delete the data in the cells?
No. A chart is a separate object that sits on top of your spreadsheet. Deleting it removes only the picture, not the numbers or formulas in your cells. All your data remains unchanged and can be used to create a new chart anytime.
What if I delete a chart by accident?
Press Ctrl+Z (or Cmd+Z on Mac) when ready to undo the deletion. This restores the chart to its exact position with all formatting. If you have made other changes since, undo may restore an earlier version instead, so act quickly.
Why does nothing happen when I press Delete?
You are probably in edit mode inside the chart rather than selecting the chart itself. Press Escape to exit edit mode, then click the chart once to select it. You should see a border with small squares around it. Then press Delete.
Can I delete a chart if the spreadsheet is protected?
Not unless you unprotect the sheet first. The sheet owner can lock which objects can be removed. Ask them for the password, unprotect the sheet, delete the chart, and re-protect if needed.
Can I undo a chart deletion if I made other changes after deleting it?
You can try pressing Ctrl+Z multiple times to step back through your recent actions. However, if too many changes have been made, undo may restore an earlier version of the entire spreadsheet rather than just the chart. For this reason, undo when ready after deleting if you want to recover the chart.