In this tutorial, you will learn how to make a line graph in google sheets with multiple lines.
Line graphs are one of the most commonly used data visualization tools because they are easy to read and simple to generate. Google Sheets makes it possible to create a line graph from spreadsheet data in just a few clicks, but what if you want to graph multiple lines of data on the same chart? Fortunately, this isn’t hard to do in Google Sheets. Read on to learn how.
New Line Graphs with Multiple Lines
The easiest way to make a line graph with multiple lines in Google Sheets is to make it from scratch with all the lines you want. Here’s how:
Ensure the data sets for the multiple lines you want to add are each in their own column so that Google Sheets can generate the graph correctly. Be sure to also include a column for the X axis of the graph, or labels for the data points. Note that the labels/X-axis column should be before the other data columns
Select the data columns, including the headers, and open the Insert menu, then choose Chart
In the Chart editor, under Chart Type, select the Line Chart or Smooth Line Chart option
The line chart with multiple lines will appear as a floating element above the cells. Drag and drop it to move it as needed
Add Lines to an Existing Graph
If you already have a line graph with a single line and have put work into customizing it so don’t want to start from scratch, you can also add lines to an existing line graph by following these steps:
Select the line graph and click on the 3-dot menu icon in the upper-right corner, then choose Edit Chart
In the Chart Editor, scroll down to the Series section and click Add Series
Click the grid icon at the right of the search field to select a data range
Then enter the range reference for the new line into the popup that appears, or use the mouse to select the cells in the spreadsheet
Click OK to add the series to your graph as a new line
Repeat the above steps till all desired lines have been added
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to make a line graph in google sheets with multiple lines. Want more? Check out all the Google Sheets Tutorials.