How To Make A Line Graph In Google Sheets With Multiple Lines

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:

Step 1

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

Step 2

Select the data columns, including the headers, and open the Insert menu, then choose Chart

Step 3

In the Chart editor, under Chart Type, select the Line Chart or Smooth Line Chart option

Step 4

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:

Step 1

Select the line graph and click on the 3-dot menu icon in the upper-right corner, then choose Edit Chart

Step 2

In the Chart Editor, scroll down to the Series section and click Add Series

Step 3

Click the grid icon at the right of the search field to select a data range

Step 4

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

Step 5

Click OK to add the series to your graph as a new line

Step 6

Repeat the above steps till all desired lines have been added

Summary

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.