Remove a Column from an Excel Chart Without Deleting Data

Charts & pivot tables · Updated November 20, 2026

To remove a column from an Excel chart without deleting its worksheet data, select the chart, open Chart Design > Select Data, select the series you want to remove, and choose Remove. If you mean just one plotted column rather than a whole series, use the chart’s filter or select that individual data point instead.

First, identify what the column represents

In a column chart, a visible column is usually a data point in a series. The chart’s legend identifies series; the category labels along the horizontal axis identify groups such as months, products, or regions. Depending on how the source table is arranged and whether the chart is clustered or stacked, a column may represent an entire series at one category, or one category’s value within a series.

This distinction matters because removing a series and removing one data point are different operations. For example, a chart with separate series for East and West and categories for January and February has four plotted columns. Removing the West series removes both West columns. Removing the West value for January removes only that one plotted point. If the chart has only one series, removing the series would leave no plotted data at all.

  • Remove a series: take all its plotted values out of the chart.
  • Remove a category: hide that category and its corresponding plotted values.
  • Remove one data point: hide one value while leaving the rest of its series visible.

Remove an entire series with Select Data

Use this method when you want to remove all columns belonging to a named series, such as one salesperson, product, or region. It changes what the chart plots; it does not require deleting the source cells.

  1. Click the chart once to select it.
  2. On the ribbon, select Chart Design > Select Data. The Chart Design tab appears when a chart is selected.
  3. In the Select Data Source window, find the Legend Entries (Series) list.
  4. Select the series name to remove, then select Remove.
  5. Select OK and check the chart and legend.

For instance, if the legend lists North, South, and Central, removing South takes its values out of the chart for every displayed category. The worksheet column containing South’s figures remains in place. If you chose the wrong series, reopen Select Data and add or restore the series by selecting the relevant range, or use Undo immediately with Ctrl+Z on Windows.

Remove only one column or data point

If one individual bar is the problem, first try selecting just that point. Click the chart once, then click the relevant column again so that only the individual data point—not the whole series—is selected. Press Delete. The source value in the worksheet is not erased by this chart-selection action. Selection can be fiddly in a dense chart, so look for selection handles around one column rather than around every column of the same color.

Another option is the chart’s filter control. Select the chart and, if the funnel-shaped Chart Filters button appears beside it, open it and review the Categories and Series lists. Uncheck the item you want hidden, then choose Apply. This is useful for temporarily excluding a category or an entire series, and you can bring it back by checking it again.

There is an important limitation: filtering a category normally hides that category for all series, not just one series’ value at that category. If you need to omit exactly one value but retain the other columns for that category, select and delete that individual data point or adjust the chart’s source data deliberately. Check the result carefully, especially in stacked charts, where hiding one segment changes the apparent total.

Hide a category without removing worksheet data

When the column you want gone represents a whole category—perhaps one month or one product—use Chart Filters and uncheck that category if the filter control is available. This keeps the category in the worksheet and lets you restore it later. The chart’s axis labels and plotted values update together, which is generally clearer than deleting a worksheet column just to change one chart.

You can also use Chart Design > Select Data to adjust the chart’s data range or category labels. In the Select Data Source window, the Horizontal (Category) Axis Labels area has an Edit option, while the series list controls which series are plotted. Take care not to shorten or shift a range unintentionally: a changed range may exclude neighboring months or include a header as data. If other charts use the same cells, changing those cells can affect those charts too.

What happens to the worksheet data?

Removing an item from the chart is not the same as deleting its cells. Removing a series through Select Data changes the chart’s plotted series. Filtering a category changes what is displayed. Deleting a worksheet column, by contrast, changes the workbook’s data layout and may affect formulas, tables, and other charts that refer to it. Excel may update chart references when cells are deleted, but that is a broader workbook edit than most people need for a chart-only change.

If you want to preserve a complete record, leave the original data alone and make the change in the chart. If the chart is based on an Excel table, adding rows to the table may also expand the chart’s source data automatically. A series removed from the chart can therefore remain available in the table and may be included again if you later add it back or revise the chart range.

Excel for Mac and Excel for the web

In Excel for Microsoft 365 on Windows, the standard route is Chart Design > Select Data. Excel for Mac has a similar chart-selection workflow and a Chart Design tab, though the ribbon layout and the way the Select Data dialog is presented can vary by release. Select the chart first, then look for the chart design controls and the series list.

Excel for the web supports editing charts, but its ribbon and chart controls can be more limited or arranged differently from the Windows desktop app. If you do not see a Select Data command or cannot select an individual point, open the workbook in the desktop app for the full chart-editing controls. The Chart Filters funnel may also be absent depending on the interface or chart selection state. Avoid deleting worksheet cells as a workaround unless you intend to change the workbook data itself.

Common problems and how to fix them

  • The whole chart disappears: You may have removed its only series. Re-add the data range in Select Data or use Undo, then remove a single point or category instead.
  • Every column of one color disappears: That color represents a series, and the series was removed. Add it back and select only the intended point if you meant to remove one column.
  • The wrong category is hidden: Reopen Chart Filters and check the category again, or review the axis labels in Select Data to confirm the source range.
  • The legend still shows an unexpected item: Check whether another series or category remains, and confirm that the legend is reflecting the chart’s current data. A manually edited legend or chart formatting can make it look different from the plotted data.
  • A new column returns later: The chart may include a table or source range that expands as data is added. Review Select Data and the source range before changing worksheet structure.

Before making several chart edits, consider saving a copy of the workbook if the chart is part of a report or dashboard. Chart filtering is easy to reverse, but changes to source ranges or deleted worksheet cells can have wider effects. After editing, inspect the title, legend, axis labels, and any data labels so they still describe the information being shown.

Which method should you choose?

Choose the operation that matches your goal rather than deleting a worksheet column by default:

  • Use Select Data > Remove to remove a complete series from one chart.
  • Use Chart Filters to hide or restore a category or series without removing its data.
  • Select an individual data point and press Delete when only one plotted value should disappear.
  • Delete worksheet cells only when you intend to change the data layout, not merely the chart’s appearance.

These choices are not interchangeable. For example, a filter may hide a category across multiple series, while deleting one selected point targets a single plotted value. If the chart is a stacked column chart or a chart used for decision-making, verify that removing the item does not make the remaining display misleading.

Frequently Asked Questions

How do I remove one series from an Excel chart?
Select the chart, choose Chart Design > Select Data, select the series under Legend Entries (Series), choose Remove, and confirm. The worksheet values remain in place.

Can I remove one bar without deleting its worksheet value?
Yes. Select the chart, click the specific bar again to select only that data point, and press Delete. Confirm that only one point is selected before pressing the key. You can also use a chart filter when you want to hide a category or series.

How do I get a removed column back?
If you used Chart Filters, reopen the filter and check the category or series. If you removed a series, open Select Data and add the series back using its worksheet range. Ctrl+Z on Windows (Command+Z on Mac) can undo a recent change.

Does deleting a column from the chart delete the data in Excel?
No, removing a plotted series or data point from the chart does not by itself delete its worksheet value. Deleting a worksheet column is a separate action and can affect other workbook content.

Why can’t I see the Chart Filters button?
The funnel button appears when a supported chart is selected in some Excel desktop interfaces, but it may not be available or visible in every version or in Excel for the web. Use Chart Design > Select Data instead, or open the workbook in desktop Excel if the web interface lacks the control.

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.