Add a data series to a chart in Excel 2016 for Windows

After creating a chart, you might add another data series to your worksheet that you want to include in the chart. If your chart is on the same worksheet as the data you used to create the chart (also known as the source data), you can quickly drag around any new data on the worksheet to add it to the chart.

  1. On the worksheet, in the cells directly next to or below the source data used to create the existing chart, enter the new data series to add.

  2. Click anywhere in the chart.

    The source data is selected on the worksheet showing the sizing handles.

    Selected source data

  3. On the worksheet, drag the sizing handles to include the new data.

    The chart is updated automatically and shows the new data series you added.

If your chart is on a separate chart sheet, dragging might not be the best way to add a new data series. In that case, you can enter the new data for the chart in the Select Data Source box.

Add a data series to a chart on a chart sheet

  1. On the worksheet, in the cells directly next to or below the source data of the chart, type the new data and labels you want to add.

  2. Click the chart sheet with the chart to update.

  3. Right-click the chart, and then choose Select Data.

    The Select Data Source box appears on the worksheet with the source data of the chart.

    Select Data Source dialog box

  4. Leaving the box open, click in the worksheet, and then select all data to use for the chart, including the new data series.

    The new data series appears under Legend Entries (Series).

  5. Click OK to close the box and to return to the chart sheet.

Tip:  Once you have your data series in place, you can easily show or hide any of them by applying a chart filter.

Help us improve Excel

Do you have suggestions about how we can improve the next version of Excel? If so, please check out the topics at Excel User Voice.

Related information

Change the data series in a chart

Rename a data series

Add data labels to a chart

Add axis titles to a chart in Office 2016

Available chart types in Office

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×