How to remove a data series from a chart in Excel Mac

To update your Microsoft Excel worksheet, you can add a data series to the source data and also update the worksheet chart to make your data meaningful to your colleagues and clients. Applying an Insert command will add more cells to enter your categories and values. As an alternative, applying the Chart Filters and the Select Data Source options will enable you to rearrange, hide or remove a data series from the chart.

Add Data Series to a Worksheet

1. 1.

   Enter the new data series in the cells next to or below the source data. If there are no empty cells, insert a new row by right-clicking the row below where you want to insert the new row. Point over “Insert,” select “Entire row” and then click “OK.” To insert a new column, right-click the cell to the right where you want to insert the new column, point over “Insert” and then click “Entire column” followed by “OK.”

2. 2.

   Click inside the chart to display the worksheet data with colored sizing frames.

3. 3.

   Click and drag the sizing handle to include the new data series and update your chart. Save this worksheet.

Charts

1. 1.

   Click inside your chart to bring up the three chart commands to the side, including Chart Filters. Mouse over the icons to display the commands.

2. 2.

   Select “Chart Filters,” and then choose “Select Data” to open the Select Data Source dialog box.

3. 3.

   Select the series in the Legend Entries (Series) box, and then click “Edit” to open the Edit Series box.

4. 4.

   Update the Series Name field or the Series Values field. To reposition the data series, click the “Move Up” or “Move Down” arrow buttons. Click “OK.”

   Once you have a chart, you may want to add or remove data series. If all data series are in contiguous cells, it's easy to just select the chart, and drag the data range selectors to include or exclude cells as needed.

   However, if the data series are not in contiguous cells, you'll need to use another approach.

   For example, here if we want to plot all 3 test results, but ignore the two quiz results, we can't use the data range selector.

   If you haven't put much time into a chart, it's probably easiest to create a new chart, holding down the control key to select the data you want to include.

   But, if you have an existing chart you want to build on, you can do that too.

   Right click on the chart and choose Select Data.

   Data series are listed on the left. Click the Add button, then make a selection for the series name, and the series values.

   When you click OK, the new series will be added to the chart.

   Notice when you've added data series in non-contiguous cells, you won't see the data range selectors on the worksheet when the chart is selected.

   However, if I remove the second data series, the data range selector are again visible.

   Finally, if you're using Excel 2013 or later, you can also add data series with the chart filter.

   The trick here is to first include all data, then use the chart filter to remove the series you don't want.

   For example, here I can select the chart, then drag the data selector to include all 3 tests and the 2 quizzes.

   I don't want to include the quizzes in the chart, but I can easily remove with the chart filter.

   Just click the filter icon, and uncheck quiz 1 and quiz 2.

   Now when the chart is selected, the data range selector will still show that all data is included.

   But if I check the source data, both quiz 1 and quiz 2 appear as disabled data series.

   In other words, the list of data series shown in the source data window will stay in synch with the chart filter. You can work with either to include or exclude data series in an Excel chart.

   For a chart you create, it is normal to change or remove data series in it. This step-by-step guide demonstrates how to change or remove data series from a chart in Excel.

   Change data series from a chart in Excel
   Remove data series from a chart in Excel

   ---

   Change data series from a chart in Excel

   As shown in the screenshot below, you have created a column chart based on the original data in the range A1:E5. Now you add a new series to the original data and want to change the data series “Promotions” to the newly added series “Profits”. Please do as follows.

   

   1. Right click the chart and choose Select Data from the right-clicking menu.

   

   2. In the opening Select Data Source dialog box, select the series you want to change and then click the Ebdit button in the Legend Entries (Series) box.

   

   3. In the Edit Series dialog box, select the new series name and the new series values separately in the Series name and Series values boxes, and then click the OK button.

   

   4. Then it returns to the Select Data Source dialog box. You can see that the old series is replaced by the new one, click OK to save the changes.

   

   The specified data series is now changed in the chart.

   ---

   Remove data series from a chart in Excel

   If you just want to remove a certain data series from a chart in Excel, for example, to remove the Promotions series from the chart, you can follow the following steps to get it done.

   

   1. Right click the chart and choose Select Data from the right-clicking menu.

   

   2. In the opening Select Data Source dialog box, select the series you want to remove and then click the Remove button in the Legend Entries (Series) box. And finally click OK to save the changes.

   

   The specified data series is now removed from the chart.

   Note: You can just hide the data series without removing it from the chart.

   To hide a data series in a chart, you need to select the chart, click the Chart Filters button, uncheck the series you don’t want to display in the chart, and then click the Apply button. See screenshot:

   How do I change the series in an Excel chart Mac?

   On the Design tab, in the Type group, click Change Chart Type. In the Change Chart Type dialog box, click a chart type that you want to use.

   How do you remove a data series from a chart label?

   Click a data label one time to select all data labels in a data series or two times to select just one data label that you want to delete, and then press DELETE. Right-click a data label, and then click Delete. Note: This removes all data labels from a data series.

   How do I remove a series line from a graph?

   Remove other lines Click the chart with the lines, and then click the Chart Design tab. Click Add Chart Element, click Gridlines, and then click More Gridline Options. Select No line. You can also click the line and press DELETE .