# How to Plot Multiple Lines – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on June 13, 2022

This tutorial will demonstrate how to plot multiple lines on a graph in Excel and Google Sheets.

## How to Plot Multiple Lines on an Excel Graph

### Creating Graph from Two Sets of Original Data

1. Highlight both series
2. Click Insert
3. Select Line Graph
4. Click Line with Markers

### Final Graph with Multiple Lines

Below you can see what the graph looks like as we compare how clicks change and sales change in the same period. This can help determine if there are trends among the two datasets.

### Adding to Graph in Order to Create Multiple Lines Graph

Instead of the scenario above, in this section, we’ll show what to do if you want to add to the graph to create a multiple lines graph. We’ll start with a single line graph below and show how to add another dataset.

1. Right click on the graph
2. Click Select Data

4. Select Series Name with updated header for new series

5. Select Series Values with updated values for new series

## How to Plot Multiple Lines on Google Sheets

### Creating Graph from Two Sets of Original Data

In Google Sheets, we want to set up the same data. But we also want to add the information that we want on the X Axis. Different from Excel, Google Sheets doesn’t automatically create this.

### Create a Graph

1. Highlight Graph
2. Click Insert
3. Select Chart

### Change to Line Graph

Once created, a bar on the right hand side will appear

1. Click the chart under Chart Type. In this scenario, it is Combo Chart
2. Change the chart to Line Chart

### Adding to Graph in Order to Create Multiple Lines Graph

Similar to how we showed in Excel, we’ll show how to add to a single line graph to create a multiple line graph. We’ll start with the dataset showing month and clicks per month.

### Adding Second Line to Graph

1. Right click on Graph
2. Select Data Range

4. Click Select a Data Range

5. Highlight new series and Click OK