Deleting a data series  in Microsoft Excel 2019

To remove data from your chart is easy. As you will see from thefollowing chart, the user selected the January data series. If this data is nolonger required, delete it, as follows:

  1. Make sure the series is selected (tiny light blue circles willappear if clicking once on the Januaryseries).
  2. Press Delete on yourkeyboard.
  3. You will notice that January willdisappear from the legend, the chart, and from the selected chart dataon the worksheet. There are other methods to delete a data series, suchas right-clicking on a series and choosing Delete from the shortcut menu provided; orselecting the chart from which you would like to remove a series andthen clicking on the Select Data iconlocated on the Design tab.
  4. The Select Data Source dialog boxwill appear, as illustrated in the followingscreenshot:
ms office 868
  1. Click to select the January dataseries to remove this from the chart.
  2. Click on the Remove icon to deletethe series from the chart, and then click on the OK command to update the chart. The dataselection is then removed from the worksheet data and the chart, asfollows:
ms office 506

Let’s learn how to add a data series now that you have been throughthe steps to delete a series.

Leave a Comment