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:

**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