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
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
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
In the Chart Editor sidebar, under the Series section, click on Add Series below the list of existing series
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
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.
The chart will update with the new data series
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.