The fastest way to remove a chart from your spreadsheet

To delete a chart in Excel, click on it once to select it, then press Delete. The entire chart disappears when ready. If you accidentally delete it, press Ctrl+Z (or Cmd+Z on Mac) to undo.

That is the complete process. Charts in Excel are separate objects that sit on top of your data — they are not part of the cells themselves. Deleting a chart does not touch the numbers or formulas underneath it. Your data stays exactly as it was.

The only time deletion gets slightly more complicated is if the chart is embedded inside a cell or locked as part of a protected sheet. Both situations are rare, and both have straightforward workarounds covered below.

Key Takeaways

  • Click the chart once to select it, then press Delete — no other steps needed.
  • Deleting a chart never affects the data in your spreadsheet, only the visual representation of it.
  • If you delete a chart by accident, Ctrl+Z (or Cmd+Z on Mac) restores it when ready.
  • Charts that are part of a protected sheet may require you to unprotect the sheet first before deletion is possible.
  • If a chart will not select when you click it, it may be grouped with other objects and need to be ungrouped before you can delete it alone.

Selecting the chart correctly

The most common reason someone thinks a chart cannot be deleted is that they have not actually selected it. When you click on a chart, you should see a border with small squares (called handles) around the entire chart. That border means the chart is selected and ready to be deleted.

If you click on the chart and see selection handles around only one element inside it — like a single bar or the legend — you have selected that piece instead of the whole chart. Click somewhere outside the chart first to deselect everything, then click directly on the chart's border or background area. You should now see handles around the entire chart.

Once the whole chart is selected, Delete removes it completely. If you see handles around only part of the chart, pressing Delete will remove just that piece, not the whole thing.

Undoing an accidental deletion

If you delete a chart and when ready realize you did not mean to, press Ctrl+Z (Windows) or Cmd+Z (Mac). Excel keeps a history of your recent actions, and undo will restore the chart exactly as it was, including all its formatting and data connections.

Undo works even if you have already clicked somewhere else in the spreadsheet. However, if you close the file without saving, the undo history is lost. If you have already saved the file after deleting the chart, you will need to reopen the previous version if your system has file recovery enabled, or rebuild the chart from scratch.

Deleting a chart from a protected sheet

If your spreadsheet is protected (a feature that prevents accidental changes to formulas or structure), you may not be able to delete a chart even after selecting it. When you press Delete, nothing happens, or you see a message saying the sheet is protected.

To delete the chart, you must first unprotect the sheet. Go to the Review tab (or Sheet menu on Mac), find the Unprotect Sheet button, and click it. You may be asked for a password if one was set when the sheet was protected. Once unprotected, select the chart and press Delete as normal. You can then re-protect the sheet if needed by clicking Protect Sheet in the same menu.

Removing a chart that is grouped with other objects

Sometimes a chart is grouped together with other shapes or objects on the spreadsheet. When this happens, clicking the chart selects the entire group instead of just the chart. If you press Delete, the whole group disappears, not just the chart.

To delete only the chart, you must ungroup it first. Right-click on the selected group and choose Ungroup (or Group > Ungroup on Mac). The objects separate, and you can now click the chart alone to select it. Press Delete to remove only the chart, leaving the other objects in place.

Clearing chart data without deleting the chart itself

Sometimes you want to keep the chart but remove or change the data it displays. Deleting the chart is not the right move in this case. Instead, you can edit the chart's data range or clear the cells the chart is reading from.

To change what data a chart shows, right-click the chart and select Edit Data or Data Table (the exact wording depends on your Excel version). A window opens showing which cells the chart is pulling from. You can modify the range, remove rows or columns, or point the chart to different data entirely. The chart updates automatically to reflect the new data.

If you want to clear the numbers but keep the chart structure, select the cells containing the data and press Delete. The chart will appear empty but remain on your spreadsheet, ready to be filled with new numbers later.

Deleting multiple charts at once

If your spreadsheet has several charts and you want to remove them all, you can select multiple charts and delete them together. Click the first chart, then hold Ctrl (or Cmd on Mac) and click each additional chart you want to remove. All selected charts will show handles around them. Press Delete, and all of them disappear at once.

This is faster than deleting them one by one, but be careful — you cannot undo the deletion of multiple charts as easily if you change your mind. If you are unsure, delete them one at a time so you can undo individual deletions if needed.

Frequently Asked Questions

Does deleting a chart delete the data underneath it?

No. Charts are visual objects that sit on top of your spreadsheet data. Deleting a chart removes only the picture, not the numbers or formulas in the cells. Your data remains unchanged and can be used to create a new chart anytime.

What if I delete a chart and cannot undo it?

If undo is no longer available (usually because you closed and reopened the file), you will need to rebuild the chart. Select the data again, go to the Insert tab, choose Chart, and recreate it with the same settings. If you saved the file before deleting, you may be able to recover a previous version through your file system or cloud storage.

Can I delete just the legend or title of a chart without deleting the whole chart?

Yes. Click the chart once to select it, then click specifically on the legend or title you want to remove. When that element is selected (you will see handles around only that piece), press Delete. Only that part disappears. The rest of the chart stays intact.

Why does my chart not disappear when I press Delete?

The sheet is likely protected, or you have selected only part of the chart instead of the whole thing. Try clicking the chart's border or background to select the entire object, not just one element inside it. If that does not work, check the Review tab for an Unprotect Sheet option.