How to Delete Pie Chart in Excel
Need to remove a pie chart from your Excel spreadsheet? Getting rid of an old or unwanted chart is a simple task that only takes a couple of seconds. This guide will walk you through the fastest ways to delete a pie chart, as well as share some practical tips for managing charts in more complex reports.
The Easiest Way: Using Your Keyboard
The most direct method for deleting a pie chart in Excel is by using the Delete or Backspace key on your keyboard. It's a two-step process that you'll master instantly.
Step-by-Step Instructions:
Select the Pie Chart: Click once on any part of the pie chart. You'll know it's selected when you see a border appear around the entire chart object with small circles (called adjustment handles) at the corners and midpoints. Be careful not to double-click or click on a specific element inside the chart (like a single slice or the legend), as this might select only that item. To select the whole chart, click on the blank white space inside the chart area or on its border.
Press the
DeleteKey: With the chart selected, simply press theDeletekey on your keyboard. The chart will instantly vanish. Alternatively, you can also press theBackspacekey, both accomplish the same thing.
That's it. Your chart is gone. This simple click-and-delete method works for any type of chart in Excel, including bar charts, line graphs, and scatter plots.
A Quick Tip: What if Only One Slice Is Selected?
A common slip-up is accidentally clicking a single slice of the pie twice. When this happens, Excel thinks you want to format that specific data point. You will see selection handles around that slice only, not the entire chart.
If you press Delete now, you might just remove that slice's data label or styling, not the chart itself. If this happens, just click on a blank part of your worksheet to deselect it, then click once on the chart's border or background area to re-select the whole object correctly. From there, you can press Delete as intended.
The Right-Click Method: Using the “Cut” Command
If you prefer using your mouse over keyboard shortcuts, the right-click context menu is another excellent option. This method uses the "Cut" command, which also removes the chart from your sheet.
Step-by-Step Instructions:
Select the Pie Chart: Just like before, click once on the chart's border or in an empty area within the chart to select the entire object.
Right-Click to Open the Menu: Move your mouse cursor over the selected chart border and right-click. This will bring up a context-sensitive menu with a list of actions you can perform on the chart.
Select “Cut”: From the menu, find and click on the “Cut” option (it usually has a scissors icon next to it). This will remove the pie chart from your worksheet.
The primary difference between using Delete and Cut is that Cut also copies the chart to your clipboard. This means you could immediately paste it somewhere else if you wanted to move it instead of deleting it permanently. If your only goal is deletion, either Delete or Cut work perfectly fine. After you cut the chart, if you copy something else or close Excel without pasting, the chart is effectively deleted.
Accidentally Deleted Your Chart? No Problem!
If you delete a chart and immediately regret it, you can bring it back with Excel’s Undo command. Simply press Ctrl + Z (or Cmd + Z on a Mac). You can also click the Undo arrow button in the Quick Access Toolbar at the top of the Excel window. This will reverse your last action and restore the chart.
Advanced Method: Deleting Charts with the Selection Pane
What if your spreadsheet is a complex dashboard packed with overlapping charts, shapes, and text boxes? Clicking the exact chart you want to delete can be tricky. This is where the Selection Pane comes in handy. It gives you a clean list of every object on your worksheet, allowing you to select and manage them with precision.
Why Use the Selection Pane?
It helps you select objects that are hidden behind other objects.
You can select the correct chart when many are cluttered together.
It's an organized way to see everything on your sheet at once.
How to Use the Selection Pane to Delete a Chart:
Navigate to the Home tab on the Excel ribbon.
On the far right side of the tab, find the Editing group. Click on the Find & Select dropdown menu.
From the menu that appears, choose Selection Pane….
The Selection Pane will open on the right side of your screen. You will see a list of names for all the objects on the current sheet (e.g., “Chart 1”, “Picture 3”, “Rectangle 5”).
Find the name of your pie chart in the list and click on it. The corresponding chart will be selected in your worksheet.
With the chart selected via the pane, simply press the Delete key on your keyboard.
The Selection Pane is an invaluable tool for anyone building detailed reports or dashboards. It gives you an organizational layer that makes managing complex layouts much easier.
How to Delete Multiple Charts at Once
Cleaning up an old report might require deleting several charts. Instead of removing them one by one, you can select and delete them all in a single action. There are two efficient ways to do this.
Method 1: Using Ctrl/Cmd + Click
Click on the first chart you want to delete to select it.
Press and hold the Ctrl key (or Cmd key if you’re using a Mac).
While holding the key down, click on each of the other charts you wish to delete. You will see that each chart you click becomes selected simultaneously.
Once all the target charts are selected, release the Ctrl/Cmd key and press the Delete key once.
Method 2: Using the Selection Pane
This is often the faster and more reliable method if you have many overlapping objects.
Open the Selection Pane (Home > Find & Select > Selection Pane…).
Press and hold the Ctrl key (or Cmd on Mac).
In the pane list, click on the names of every chart you want to remove.
Release the Ctrl/Cmd key and hit Delete.
Troubleshooting: Why Can't I Delete My Pie Chart?
Occasionally, you might find that you can't select or delete a chart. This usually happens for one of a few common reasons. Here’s what to check.
1. The Worksheet is Protected
If a worksheet is protected, Excel may prevent you from making edits, including deleting charts. You can check this by going to the Review tab on the ribbon. If you see a button that says Unprotect Sheet, it means the sheet is currently locked.
Solution: Click Unprotect Sheet. If the sheet is password-protected, you'll need to enter the password to proceed. Once unprotected, you should be able to select and delete your chart without issue.
2. The Chart is Grouped with Other Objects
Excel allows you to "group" multiple objects (like charts and shapes) together so they can be moved and resized as a single unit. If your pie chart is part of a group, clicking on it will select the entire group, not the individual chart.
Solution: Right-click on the grouped object. In the context menu, find the Group option, and from there, select Ungroup. This will break the objects apart, allowing you to select and delete only the pie chart.
3. Important Reminder: Deleting a Chart Does NOT Delete Your Data
One of the most important things to remember is that a chart is just a visual representation of your data - it is linked to your data but separate from it. When you delete a pie chart, you are only removing the visualization. The source data in your rows and columns will remain completely untouched. This allows you to create and delete different charts without any fear of losing the underlying information.
Final Thoughts
Removing a pie chart from your Excel file is a simple process, whether you use a quick key press, the right-click menu, or the more advanced Selection Pane for cluttered reports. With these methods, you can confidently clean up your spreadsheets and make room for new, more relevant visualizations.
As you manage data across more tools like Google Analytics, Shopify, and various ad platforms, building reports becomes a constant, time-consuming cycle of exporting CSVs and wrestling with spreadsheets. We built Graphed to solve exactly this problem. We make it easy to connect all your data sources in one place and create insightful, real-time dashboards just by describing what you need in plain English - no formulas, pivot tables, or manual refreshes required.