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:

Plot multiple lines in Excel

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:

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.