How to Plot Multiple Lines in Excel (With Examples)

by Tutor Aspire February 17, 2016

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

The following examples show how to plot multiple lines on one graph in Excel, using different formats.

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

We can use the following steps to plot each of the product sales as a line on the same graph:

Highlight the cells in the range B1:D8.
Click the Insert Tab along the top ribbon.
In the Charts group, click the first chart option in the section titled Insert Line or Area Chart.

The following chart will appear:

Plot multiple lines in Excel

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

We can use the following steps to plot each of the product sales as a line on the same graph:

Highlight the cells in the range A1:H4.
Click the Insert Tab along the top ribbon.
In the Charts group, click the first chart option in the section titled Insert Line or Area Chart.

The following chart will appear:

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

We can use the following steps to plot each of the product sales as a line on the same graph:

Highlight the cells in the range A1:C5.
Click the Insert Tab along the top ribbon.
In the Charts group, click the first chart option in the section titled Insert Line or Area Chart.

The following chart will appear:

Notice that the products are displayed along the x-axis instead of the years.

To switch the rows and columns, we can click anywhere on the chart and then click the Switch Row/Column button under the Chart Design tab:

Once we click this button, the rows and columns will be switched and the years will be displayed along the x-axis: