Sometimes for data visualization, you may need to plot a line graph. In this article, I will explain how to make a line graph in Excel with multiple lines.
Here, I have described 4 methods to make a line graph in Excel with multiple lines. For your better understanding, I will use a sample dataset. Which has 3 columns. They are Product, Sales, and Profit. The dataset is given below.
1. Using Line Chart Feature to Make a Line Graph in Excel with Multiple Lines
There is a built-in process in Excel for making charts under the Charts group Feature. In addition, you can use Line Charts Feature to make a line graph in Excel with multiple lines. The steps are given below.
Steps:
- Firstly, you have to select the data. Here, I have selected the range B4:D9.
- Secondly, you have to go Insert tab.
- Now, from the Charts group section you have to choose 2-D Line >> then choose Line with Markers.
Furthermore, there are 6 features under the 2-D Line. Along with that, you can choose as your requirement. Here, I have used Line with Markers.
Now, you will see the result by clicking the Line with Markers feature.
Now, you can change the Chart Title and add the Data Labels.
Finally, you will see the following chart.
Read More: How to Make a Line Graph in Excel with Two Sets of Data
2. Making a Line Graph in Excel Through Charts Group
You can apply the Charts Group ribbon to make a line graph in Excel with multiple lines. The steps are given below.
Steps:
- Firstly, you have to go to the Insert tab.
- Secondly, from 2-D Line >> choose Line with Markers.
At this time, you can see the following blank box.
- Now, you must select the box.
- Then, from Chart Design >> choose Select Data.
Subsequently, a dialog box of Select Data Source will appear.
- Now, you must select Add from the following box.
As well as that, another dialog box will appear.
- Now, you can select or write down the Series name. Here, I have selected the Series name as Sales from the C4 cell.
- Then, you have to include Series values. Here, I have used the range C5:C9.
- Finally, press OK to get the line chart.
At this time, you will see the following line chart.
Moreover, to include multiple lines, you have to select Add feature again.
- Similarly, as in the previous one, you must select the Series name. Here, I have selected the Series name as Profit from the D4 cell.
- Then, you have to include Series values. Here, I have used D5:D9.
- Finally, press OK to get the line chart.
- After this, press OK on the Select Data Source box.
Finally, you will see the following line chart with multiple lines.
Read More: How to Make a Line Graph in Excel with Multiple Variables
Similar Readings
- Draw Target Line in Excel Graph (with Easy Steps)
- How to Draw a Horizontal Line in Excel Graph (2 Easy Ways)
- Make a Single Line Graph in Excel (A Short Way)
3. Using Context Menu Bar to Add a New Line to an Existing Chart
You can employ the Context Menu Bar to add a new line to an existing chart in Excel. In addition, Let you have the following data set. Which has 5 columns. They are Product, Sales of Jan, Profit of Jan, Sales of Feb, and Profit of Feb.
Moreover, suppose you have the following line chart with multiple lines using the data Sales of Jan and Profit of Jan.
At this time, you want to add new lines with the data for February.
- Now, you must Right-Click on the chart.
- Then, from the Context Menu Bar, you need to choose Select Data.
After that, you will see the following dialog box of Select Data Source.
- Now, you have to choose the Add feature.
After selecting the Add feature, another dialog box will appear.
- Now, you can write down or select the Series name in that dialog box. Here, I have selected the Series name as Sales of Feb from the E4 cell.
- Then, you have to include the Series values. Here, I have used the range E5:E9.
- Finally, press OK to get the line chart
- Similarly, I have added another series named Profit of Feb.
- Finally, press OK to get those charts.
Lastly, you will get the following line chart with multiple lines.
Read More: How to Make Line Graph with 3 Variables in Excel (with Detailed Steps)
4. Using Pivot Table & Pivot Chart Options for Making a Line Graph with Multiple Lines
To make a line chart in Excel with multiple lines, you can use Pivot Chart. Furthermore, without a Pivot table, you can’t use the Pivot Chart feature. In addition, you may need Table data to make a Pivot table. Let’s start with table making.
Steps:
- Firstly, you must select the data. Here, I have selected the range B4:D9.
- Secondly, from the Insert tab >> select the Table feature.
Now, a dialog box of Create Table will appear.
- Next, select the data for your table. Here, I have selected the range B4:D9.
- Make sure that “My table has headers” is marked.
- Then, press OK.
At this time, you will see the following table.
- Now, you must select the table.
- Then, from the Insert tab >> choose Pivot Table.
Subsequently, a dialog box of PivotTable from table or range will appear.
- Firstly, select the Table for your PivotTable. Here, I have selected Table1.
- Secondly, choose Existing Worksheet.
- Thirdly, select the Location for PivotTable. Here, I have selected the B12 cell.
- Finally, press OK.
At this time, you will see the following situation.
- Now, in PivotTable Fields, you have to drag Product to Rows.
- Similarly, drag Sales and Profit to the Values.
Finally, your PivotTable is done.
- Now, you must select the PivotTable.
- Then, from Inert tab >> go to PivotChart >> choose PivotChart feature.
- Now, from the following dialog box, select Line with Markers from Line.
- Then, press OK.
Finally, you will see the line charts.
Read More: How to Import Data into PowerPivot & Create Pivot Table/Pivot Chart
How to Use Scatter Feature to Add Multiple Table in Excel
You can add multiple table data to your line charts with varying X and Y values. Let’s have the following dataset. Which contains two different data tables. They are Sales of January and Sales of February.
Steps:
- Firstly, you have to choose the data range. Here, I have chosen C5:D10.
- Secondly, go to the Insert tab.
- Thirdly, from the Charts group select the Scatter feature.
At this time, you will see the following points marked with blue in the graph.
- Now, select the Chart >> go to Select Data.
As well as that, a dialog box of Select Data Source will appear.
- Now, from this box select the Add feature.
- Now, from the Edit Series dialog box, you have to write down the Series name first. Here, I have used the Series name as Feb.
- Secondly, select the Series X values. Where I have used the range C14:C18.
- Thirdly, select the Series Y values. Where I have used the range D14:D18.
- Finally, press Ok.
Now, you can change the name of the series.
- Firstly, you have to choose Series1.
- Secondly, click on the Edit option.
- Then, I have written down the Series name as Jan.
- After that, press Ok.
- Now, press Ok to the Select Data Source dialog box.
At this time, you will see the additional points colored orange.
- Now, from Chart Elements >> choose Trendline >> as Linear.
- Then, click on Jan >> press OK.
Similarly, you must do for series Feb.
Finally, you will see the following line chart with multiple lines differing the X-Y values.
Read More: How to Overlay Line Graphs in Excel (3 Suitable Examples)
Things to Remember
- For PivotTable, always you don’t have to make a Table with your data. You can directly select the data range for your PivotTable.
Practice Section
Now, you can practice the explained method by yourself.
Download Practice Workbook
You can download the practice workbook from here:
Conclusion
I hope you found this article helpful. Here, I have explained 4 different ways to Make a Line Graph in Excel with Multiple Lines. You can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.
Related Articles
- How to Make a 100 Percent Stacked Bar Chart in Excel (with Easy Steps)
- Add a Vertical Dotted Line in Excel Graph (3 Easy Methods)
- How to Edit Pivot Chart in Excel (with Easy Steps)
- How to Refresh Pivot Chart in Excel (4 Suitable Approaches)
- How to Insert a Stacked Column Pivot Chart in Excel
- How to Make a Double Line Graph in Excel (3 Easy Ways)