How to Delete a Graph in Excel

Stuck with an outdated or unnecessary graph in your Excel spreadsheet? Removing a chart is usually straightforward, but sometimes they can be surprisingly stubborn. This guide will walk you through several easy methods for deleting any graph in Excel, from the simple keyboard press to a powerful tool for finding hidden charts.

The Easiest Way: Click and Delete

For most charts embedded directly into a worksheet, deleting them is as simple as two clicks. This method works for bar charts, pie charts, line graphs, or any other visualization that lives on the same sheet as your data.

Follow these quick steps:

1. Click anywhere on the chart or graph you want to remove. You'll know it's selected when a border with small resizing handles (dots) appears around it. Be sure to click on a blank space within the chart's border, not on a specific element like a single bar or a legend, which would select that element instead of the entire chart object.
2. Once the entire chart is selected, simply press the Delete key on your keyboard. You can also use the Backspace key.

The chart will immediately disappear. The best part? This action only removes the visual graph itself, all of your original source data will remain untouched in its cells, safe and sound.

If you deleted a graph by mistake, don't worry. You can get it back instantly by using the Undo command. Just press Ctrl + Z (on Windows) or Cmd + Z (on Mac), and your chart will reappear.

How to Delete Stubborn or Hidden Charts with the Selection Pane

Have you ever encountered a chart that you can't seem to click on? Or perhaps you know there's an unwanted graph hiding somewhere on a busy worksheet, but you can't find it. This can happen if a chart is layered behind other objects, like images or other graphs. For these situations, Excel's Selection Pane is the perfect tool.

The Selection Pane gives you a complete list of every single object on your worksheet - charts, shapes, images, and text boxes. From this list, you can select, hide, or delete any object, even if you can't see it on the sheet.

Here’s how to use it:

1. Go to the Home tab on Excel’s top ribbon.
2. On the far right side of the ribbon, click on Find & Select.
3. From the dropdown menu, choose Selection Pane….

A new panel will open on the right side of your spreadsheet. It will list every object, often with generic names like "Chart 1," "Chart 2," etc.

Finding and Deleting Your Chart

Look through the list in the Selection Pane to find the name of the chart you want to delete. As you click on each name in the list, Excel will highlight the corresponding object on your sheet, helping you identify the correct one.

1. Click the name of the chart in the Selection Pane to select it.
2. Press the Delete key on your keyboard.

The chart is now gone, whether it was hidden, locked, or just hard to grab with your mouse. The Selection Pane is an excellent tool for cleaning up cluttered spreadsheets with many overlapping elements.

Embedded Charts vs. Chart Sheets: What’s the Difference?

In Excel, charts can exist in two different formats: as an "embedded" object on a worksheet or as its own dedicated "chart sheet." The method for deleting them is slightly different, so it's helpful to know which kind you're dealing with.

Deleting an Embedded Chart

This is the most common type. An embedded chart is a graphic object that sits on top of the grid within one of your normal worksheets, typically right next to the data it's visualizing. To delete this kind of chart, you can use either of the methods we've already covered: the basic click and delete or the Selection Pane.

Deleting a Chart Sheet

A chart sheet is a special worksheet within your Excel workbook that is dedicated to displaying a single, full-screen graph. You can identify a chart sheet by its tab at the bottom of the screen - it will have a small chart icon and its own name, separate from your data sheets like "Sheet1" or "Sheet2".

Because the entire sheet is the chart, you can't just click on it and press delete. To remove a chart sheet, you have to delete the whole sheet.

Here’s how:

1. Locate the chart sheet’s tab among the other worksheet tabs at the bottom-left of your Excel window.
2. Right-click on the chart sheet tab you wish to remove.
3. From the context menu that appears, select Delete.

Excel will show a confirmation pop-up warning you that you are permanently deleting the sheet. Click the Delete button to confirm. Be careful, because this action cannot be undone with Ctrl + Z after you've confirmed it.

Need to Start Fresh? How to Delete Multiple Graphs at Once

If you're working on a report or dashboard with dozens of charts and need to clear them all out, deleting them one by one would be tedious. Luckily, Excel provides a handy shortcut to select and delete all objects on a sheet at the same time.

Use this method with caution, as it will also remove any other objects on the sheet, such as images, icons, or shapes - not just charts!

Here are the steps:

1. First, make sure no single object is currently selected. Click an empty cell on your worksheet.
2. Go to the Home tab on the ribbon.
3. Click Find & Select, then choose Go To Special... from the dropdown menu. (The keyboard shortcut for this step is F5 or Ctrl + G, then click the "Special..." button).
4. In the "Go To Special" dialog box that appears, select the radio button next to Objects.
5. Click OK.

Excel will instantly select every single graphic object on the active worksheet. With all the charts (and other objects) selected, simply press the Delete key, and they will all be removed in one go.

Pro Tip: Hiding a Graph Instead of Deleting It

Sometimes you don't want to permanently delete a graph. You might want to temporarily hide it to declutter your worksheet while you focus on the data, or you may want to keep it as a "template" for later use. The Selection Pane we used earlier is perfect for this, too.

1. Open the Selection Pane (Home > Find & Select > Selection Pane...).
2. In the list of objects, find the chart you want to hide.
3. To the right of the object’s name, you'll see an icon that looks like an eye. Click this eye icon.

The eye will disappear, and so will the chart from your sheet. The chart isn't gone - it's just invisible. To bring it back, simply click the empty space where the eye icon was, and your graph will reappear instantly.

Final Thoughts

From a simple press of the "Delete" key to leveraging tools like the Selection Pane and Go To Special, you now have a full toolkit for managing and removing charts in Excel. Whether you're decluttering a report or cleaning up a workbook, these techniques ensure that no unwanted graph stands in your way.

Manually creating, managing, and deleting dozens of charts in spreadsheets can quickly become a full-time job, especially when you're also trying to pull data from platforms like Google Analytics, Shopify, or Facebook Ads. To help with that bigger reporting challenge, we built Graphed. It automates the entire process by connecting directly to your marketing and sales tools. You can create live, interactive dashboards just by asking questions in plain English, freeing you from all the manual spreadsheet work for good.