This article illustrates how to **make a line graph in excel **with multiple variables. A line graph connects different data points to show the trend and make them easily understandable. You can make a line graph in excel to portray the change in multiple data variables in relation to a particular one. Follow the article to learn how to do that easily.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from the download button below.

## Steps to Make a Line Graph in Excel with Multiple Variables

Follow the steps below to make a line graph in excel with multiple variables.

### đź“Ś Step 1: Organize Data

- Assume you have prepared the following dataset containing monthly product sales. The row headers represent the
**X**-axis variables and the column headers represent the**Y**-axis variables.

**Read More: ****How to Make Line Graph with 3 Variables in Excel (with Detailed Steps)**

### đź“Ś Step 2: Insert Line Graph

- Now, select anywhere in the dataset. Then choose
**Insert Line or Area Chart >> 2-D Line >> Line**from the**Insert**tab.

- After that, the Line Graph will be inserted as follows.

**Read More: ****How to Make Line Graph in Excel with 2 Variables (With Quick Steps)**

### đź“Ś Step 3: Switch Row/Column of the Graph

- If the Line Graph shows the columns as rows and rows as columns, you need to switch the rows in the line graph to columns and the columns to rows.
- Now, right-click on the line graph and choose
**Select Data**to do that.

- Then, select
**Switch Row/Column**and press OK.

- After that, the line graph will look as follows.

**Similar Readings**

**How to Make a Double Line Graph in Excel (3 Easy Ways)****Draw Target Line in Excel Graph (with Easy Steps)****How to Draw a Horizontal Line in Excel Graph (2 Easy Ways)**

### đź“Ś Step 4: Add Secondary Axis to Line Graph

- Now you need to add a secondary axis for the Total sales to make the line graph more presentable.
- Now double-click on the line graph for the Total sales. Then the
**Format Data Series**pane will appear on the right. You can also do that by right-clicking on the data series. Next, mark the radio button for the**Secondary Axis**.

- After that, the line graph will look as follows.

- Next, double-click on the secondary axis and change the
**Maximum**value to adjust the data series properly.

### đź“Ś Step 5: Change Chart Title and Legends

- Now, click on the chart title to rename it as required.

- Then, click on the
**Chart Elements**icon and align the**Legend**to the right.

**Read More: ****How to Make a 100 Percent Stacked Bar Chart in Excel (with Easy Steps)**

### đź“Ś Step 6: Finalize the Line Graph

- Finally, apply some text and outline formatting. After that, you will get the following result.

## Things to Remember

- You must select anywhere in the dataset before inserting the Line Graph. Otherwise, you will need to add the rows and columns manually.
- Make sure all rows and columns are selected before switching them.

## Conclusion

Now you know how to make a line graph in excel with multiple variables. Do you have any further queries or suggestions? Please let us know using the comment section below. You can also visit our **ExcelDemy** blog to explore more about excel. Stay with us and keep learning.