# How to Plot Multiple Lines in Excel (With Examples)

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.

### 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:

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:

### 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:

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:

### Example 3: Plot Multiple Lines with Flipped Columns & Rows

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: