How To Add Series In Google Sheets

In this tutorial, you volition acquire how to add together series in Google Sheets.

If you've already created a nautical chart in Google Sheets and spent some fourth dimension adjusting the settings to go the look just right, it can be frustrating to realize you need to add together more data series at a futurity time. Instead of deleting the chart and starting again from scratch, read the instructions beneath to learn how to add the new information serial to an existing nautical chart

Step 1

Commencement, brand certain the new data series is entered properly abreast the existing data serial. Data series should exist stored in rows or columns of values in your spreadsheet. If the existing data series are columns, the new one should be too. If existing data series are rows, add the new data series in a row

Step ii

Select the chart you want to update, then click on the iii-dot carte icon that appears in the upper-right corner of the selected chart. Cull Edit Nautical chart from the menu

Step three

In the Chart Editor sidebar, under the Series department, click on Add Series beneath the list of existing series

Step 4

A menu volition appear showing bachelor serial in the information range, nevertheless we want to add a new series not previously included in the nautical chart, and so click on the Information Range Selection icon to select the data range in the spreadsheet

Step 5

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

Step six

The chart will update with the new data series

Summary

Example Spreadsheet: Make a copy of the case spreadsheet

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