How To Add Series In Google Sheets

In this tutorial, you will learn how to add series in Google Sheets.

If you’ve already created a chart in Google Sheets and spent some time adjusting the settings to get the look just right, it can be frustrating to realize you need to add more data series at a future time. Instead of deleting the chart and starting again from scratch, read the instructions below to learn how to add the new data series to an existing chart

Step 1

First, make sure the new data series is entered properly beside the existing data series. Data series should be stored in rows or columns of values in your spreadsheet. If the existing data series are columns, the new one should be as well. If existing data series are rows, add the new data series in a row

Step 2

Select the chart you want to update, then click on the 3-dot menu icon that appears in the upper-right corner of the selected chart. Choose Edit Chart from the menu

Step 3

In the Chart Editor sidebar, under the Series section, click on Add Series below the list of existing series

Step 4

A menu will appear showing available series in the data range, however we want to add a new series not previously included in the chart, so click on the Data Range Selection icon to select the data range in the spreadsheet

Step 5

When the Select Data Range popup appears, click and drag to select the new series range in the spreadsheet, or type in the range reference. Then click OK.

Step 6

The chart will update with the new data series

Summary

Quick Navigation

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to add series in Google Sheets. Want more? Check out all the Google Sheets Tutorials.