How to Make a Line Graph in Excel with Multiple Lines (4 Easy Ways)

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.


Download Practice Workbook

You can download the practice workbook from here:


4 Methods to Make a Line Graph in Excel with Multiple Lines

Here, I have describedmethods 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.

 How to Make a Line Graph in Excel with Multiple Lines


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.

 How to Make a Line Graph in Excel with Multiple Lines

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.

 How to Make a Line Graph in Excel with Multiple Lines

Finally, you will see the following chart.

Read More: How to Make a Line Graph in Excel with Two Sets of Data


2. Use of Charts Group to Make a Line Graph in Excel with Multiple Lines

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.

 How to Make a Line Graph in Excel with Multiple Lines

At this time, you can see the following blank box.

  • Now, you must select the box.
  • Then, from Chart Design >> choose Select Data.

 How to Make a Line Graph in Excel with Multiple Lines

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.

 How to Make a Line Graph in Excel with Multiple Lines

At this time, you will see the following line chart.

Moreover, to include multiple lines, you have to select Add feature again.

 How to Make a Line Graph in Excel with Multiple Lines

  • 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. How to Make a Line Graph in Excel with Multiple Lines

Read More: How to Make a Line Graph in Excel with Multiple Variables


Similar Readings


3. Employing 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. How to Make a Line Graph in Excel with Multiple Lines

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.

 How to Make a Line Graph in Excel with Multiple Lines

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.

 How to Make a Line Graph in Excel 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

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.

 How to Make a Line Graph in Excel with Multiple Lines

At this time, you will see the following table.

  • Now, you must select the table.
  • Then, from the Insert tab >> choose Pivot Table.

 How to Make a Line Graph in Excel with Multiple Lines

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.

 How to Make a Line Graph in Excel with Multiple Lines

At this time, you will see the following situation.

  • Now, in PivotTable Fields, you have to drag Product to Rows.

 How to Make a Line Graph in Excel with Multiple Lines

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

 How to Make a Line Graph in Excel with Multiple Lines

Finally, you will see the line charts.

Read More: How to Import Data into PowerPivot & Create Pivot Table/Pivot Chart


Use of Scatter Feature to Add Multiple Table

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.

How to Make a Line Graph in Excel with Multiple Lines

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.

How to Make a Line Graph in Excel with Multiple Lines

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

How to Make a Line Graph in Excel with Multiple Lines

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

How to Make a Line Graph in Excel with Multiple Lines

  • Then, I have written down the Series name as Jan.
  • After that, press Ok.

  • Now, press Ok to the Select Data Source dialog box.

How to Make a Line Graph in Excel with Multiple Lines

At this time, you will see the additional points colored orange.

  • Now, from Chart Elements >> choose Trendline >> as Linear.

How to Make a Line Graph in Excel with Multiple Lines

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

How to Make a Line Graph in Excel with Multiple Lines

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.


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

Musiha

Musiha

I am Musiha, graduated from Naval Architecture and Marine Engineering Dept., BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo