How to Delete a Graph in Excel Without Removing Data

Charts & pivot tables · Updated November 20, 2026

To delete a graph (chart) in Excel without deleting the information behind it, click the chart’s outer border until the whole chart is selected, then press Delete. The chart disappears, but its source cells stay in the worksheet. If the graph is on a separate chart sheet, delete that sheet instead. Before you start, check which kind of chart you have and whether you may want to undo the change.

What You’ll Need

  • An Excel workbook open in Microsoft Excel for Microsoft 365 on Windows.
  • Permission to edit the workbook. If it is protected or read-only, you may need to unprotect it or save an editable copy first.
  • The chart or chart sheet you intend to remove. If you are unsure whether you will need it later, save a copy of the workbook before making changes.

The instructions below apply to a regular chart embedded in a worksheet. Excel for Mac and Excel for the web use the same basic selection-and-delete approach, though the keyboard key and some menu labels can differ slightly.

Step-by-Step

  1. Open the workbook and find the graph. Select the worksheet tab that contains the chart. If the workbook has many sheets, look along the bottom of the Excel window, or use the sheet navigation arrows to reveal tabs that are out of view. A chart may sit over cells rather than inside a cell, so check the full worksheet, including areas to the right or below the data. If the chart is on a tab of its own, skip to step 6.
  2. Save or make a copy if you might need the chart again. To preserve a separate version, use File > Save As and save the workbook under a different name or in a different location. This is especially useful if the chart contains custom formatting or took time to build. You can also rely on Undo immediately after deletion, but Undo is not a permanent backup and may no longer restore the chart after you close the workbook or perform many other actions.
  3. Select the chart as an object. Click once on an empty part of the chart’s outer edge, such as the border around the chart area. When the whole chart is selected, a frame with handles appears around its outside. Avoid clicking directly on a bar, line, legend, title, or axis first; those clicks may select an individual chart element rather than the complete chart. If a chart element is selected, click a blank section of the border instead.
  4. Check that the entire chart is selected. Look for selection handles around the chart’s perimeter, not just around a title or legend. If you see handles around only one part, click the outer edge again. You can press Esc once to move out of editing a chart element, then click the border. This confirmation matters because pressing Delete while an element is selected can remove that element while leaving the rest of the chart behind.
  5. Press Delete. On a Windows keyboard, press the Delete key once after the whole chart is selected. Excel removes the chart object from the worksheet. This does not clear the cells used to create the chart, so labels, dates, totals, and other source values remain in place. If the chart stays visible, check whether you selected the complete chart and repeat the selection carefully.
  6. Confirm that the chart is gone and the data remains. Check the original data range and make sure its values are still present. Click a few cells if needed to confirm that the worksheet contents were not removed. If you deleted the wrong item, press Ctrl+Z immediately on Windows to undo the deletion. On Mac, use Command+Z. Undo can reverse the deletion as long as it is still in Excel’s undo history.
  7. Delete a chart sheet only if you mean to remove the whole sheet. A chart sheet is a separate worksheet tab that displays a chart and usually has no regular cell grid. Right-click that chart’s tab and choose Delete, then confirm the prompt if Excel asks. You can also use Home > Delete > Delete Sheet when the chart sheet is active. Deleting a chart sheet removes that sheet from the workbook; it does not normally delete the source data stored on other worksheets. Check the confirmation dialog and the sheet name before you proceed.

For Excel for Mac, click the chart’s outside border and press Delete (often labelled Backspace on Mac keyboards). If your keyboard has a separate forward Delete key, the key labelled Delete may require Fn; Backspace is generally the key that removes a selected object. In Excel for the web, select the chart’s border and press Delete on your keyboard. If keyboard deletion does not work in the web version, select the chart and use the available Delete command from its context menu, if shown.

Common Mistakes

Clearing cells instead of removing the graph: Clicking and dragging across the source data selects worksheet cells, not the chart. Pressing Delete then clears the selected cell contents. To remove the graph, select its outside frame. If you accidentally cleared values, use Undo right away, then select the chart itself.

Deleting only a chart element: Excel lets you select a chart title, legend, data series, axis, or other component separately. Deleting one of these elements changes the chart but does not remove the whole object. Look for handles around the entire chart before pressing Delete.

Removing a sheet when you meant to remove a chart: A chart can be embedded over a worksheet or displayed on a dedicated chart sheet. Pressing Delete on a selected embedded chart removes just the chart. Choosing Delete for a sheet tab removes the entire sheet, which may contain other objects or content. Take a moment to identify the tab and read Excel’s confirmation prompt.

Assuming the source data will disappear too: A standard chart is a visual representation of cells. Deleting the chart does not erase those cells. Conversely, deleting the source data is not the right way to remove the chart; it may leave an empty or incomplete chart behind.

Forgetting that the workbook has more than one chart: A worksheet can contain several charts, and a workbook can have charts on multiple tabs. Removing one graph does not remove copies elsewhere. Check the relevant worksheets and chart sheets if your goal is to remove every version.

Tips

Use the selection frame as your visual check. The outer handles are the clearest sign that Excel has selected the whole chart. If selecting the border is difficult because the chart is crowded by other objects, click a small visible portion of the outside edge rather than a plotted data point. You can also move other overlapping objects temporarily, but make a note of their positions so you can restore them.

Know what you are keeping. Removing an embedded chart generally leaves the worksheet’s source cells, formatting, and formulas untouched. If the chart is linked to a PivotTable or another data source, deleting the chart still removes the visual object, not the underlying data source. Avoid deleting related tables or worksheets unless you intend to remove those too.

Use Undo for an immediate correction. Ctrl+Z on Windows and Command+Z on Mac are useful if you remove the wrong chart. Undo is most dependable before you make many subsequent edits. For a change you may need to reverse later, make a separate workbook copy instead of treating Undo as long-term storage.

Check whether you want to hide rather than delete. If you only need a cleaner view for a while, consider moving the chart out of the way or placing it on another worksheet rather than removing it. That keeps the chart available for later. If you want to permanently remove it from the workbook, delete the chart object and save the workbook.

Save after checking the result. Once you have confirmed the correct chart is gone and the data remains, save with Ctrl+S on Windows or Command+S on Mac. If you made a copy at the start, make sure you are saving the intended file, not the original or the backup by mistake.

Troubleshooting

Pressing Delete clears cell values instead of removing the graph: The chart was probably not selected. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Then click the chart’s outside border until handles appear around the full chart, and try Delete again. If you cannot see a border, click near a chart corner or use a blank strip around the chart area.

Only the title, legend, or one data series disappears: That component was selected rather than the full chart. Undo the change, press Esc if you are editing a chart element, and click the outermost chart frame. Confirm that the handles surround the whole chart before pressing Delete.

You cannot select the chart: The worksheet may be protected, the chart may be behind another object, or the chart may be on a different tab. If the sheet is protected, go to Review > Unprotect Sheet if you have permission and the required password. If another object is covering the chart, try selecting a visible edge. Also check other worksheet tabs and chart sheet tabs. In a shared or read-only workbook, ask for edit access or save an editable copy if permitted.

The chart seems to come back: Check whether you are viewing a different worksheet, opening another saved copy of the workbook, or looking at a chart that is recreated by a refresh or an automated process. A normal deleted chart does not reappear simply because its source data remains. If it returns after you refresh a PivotTable or reopen the file, review the workbook’s setup or ask its owner whether a template, macro, or data-refresh process creates it again.

Excel asks whether to delete a sheet: You likely selected a chart sheet tab or chose a sheet deletion command. Cancel if you only wanted to remove an embedded chart. Return to the worksheet containing the graph, select its outer border, and press Delete. If you do intend to remove a chart sheet, verify that the correct tab is active and that you do not need any content on it before confirming.

Undo is unavailable or does not restore the graph: Excel’s undo history may have been cleared, or too many later actions may have replaced the relevant undo step. If you saved a backup, open it or copy the chart back from it. You can also use version history if the workbook is stored in OneDrive or SharePoint and versioning is available. Otherwise, recreate the chart from its source data.

Frequently Asked Questions

Does deleting a graph in Excel delete its data?

No. Deleting an embedded chart removes the visual chart object, not the cells it uses as its source. The worksheet’s values and formulas stay in place unless you separately delete or clear those cells.

How do I delete a graph without selecting its data?

Click the chart’s outer border rather than dragging across worksheet cells. Confirm that selection handles surround the entire chart, then press Delete. If the cells are highlighted, click the chart edge and check the selection again.

What is the difference between deleting a chart and deleting a chart sheet?

An embedded chart sits on top of a worksheet and can be removed by selecting its frame and pressing Delete. A chart sheet has its own tab; deleting it removes the whole sheet. Check which type you have before using a sheet-tab Delete command.

Can I recover a chart after deleting it?

Usually, press Ctrl+Z on Windows or Command+Z on Mac immediately after deletion. If Undo is no longer available, restore a workbook copy or an available OneDrive or SharePoint version, or recreate the chart from its source data.

Can I delete a graph in Excel for Mac or Excel for the web?

Yes. Select the chart’s outside border and delete it. On Mac, Backspace is commonly used to remove the selected object; in Excel for the web, use the keyboard Delete key or an available context-menu Delete command.

Why does the chart remain after I press Delete?

The full chart may not be selected, or the worksheet may be protected. Click the outside frame and look for handles around the whole chart. If the sheet is protected, unprotect it with permission before trying again.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.