How to Plot Multiple Lines in Google Sheets (With Examples)


You can plot multiple lines on the same graph in Google Sheets by simply highlighting several rows (or columns) and creating a line plot.

The following examples show how to do so.

Example 1: Plot Multiple Lines with Data Arranged by Columns

Suppose we have the following dataset that displays the total sales for three different products during different years:

To plot each of the product sales as a line on the same graph, simply highlight the cells in the range A1:D8 and then click the Insert tab along the top ribbon and then click Chart:

In the Chart Editor window that appears on the right side of the screen, click the dropdown arrow under Chart Type and click on Line chart.

The following line chart will automatically appear:

Google sheets plot multiple lines

The x-axis displays the years, the y-axis displays the total sales, and the three individual lines represent the sales for each of the three products.

Feel free to click on specific elements in the plot to change the colors of the lines, the legend location, the title, and the axis labels.

Example 2: Plot Multiple Lines with Data Arranged by Rows

Suppose we have the following dataset that displays the total sales for three different products during different years, arranged by rows:

To plot each of the product sales as a line on the same graph, simply highlight the cells in the range A1:H4 and then click the Insert tab along the top ribbon and then click Chart.

In the Chart Editor window that appears on the right side of the screen, click the dropdown arrow under Chart Type and click on Line chart.

The following chart will appear:

Google sheets plot multiple lines

Notice that this line chart matches the one we created in the previous example.

Additional Resources

How to Create a Stem-and-Leaf Plot in Excel
How to Create a Dot Plot in Excel
How to Create Side-by-Side Boxplots in Excel
How to Create an Ogive Graph in Excel

Leave a Reply

Your email address will not be published.