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