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

Get FREE Advanced Excel Exercises with Solutions!

While working with two different sets of data, plotting them in a line graph can make it easier to analyze and interpret. Excel can be helpful in this case. The main focus of this article is to explain how to make a line graph in Excel with two sets of data.


Make A Line Graph in Excel with Two Sets of Data: 3 Steps

To explain this whole process I have taken two different sets of data. One set contains Sales and Profit for Texas and another one contains Sales and Profit for Missouri. I will be making a Profit vs. Sales graph for these two sets of data.

3 Steps to Make A Line Graph in Excel with Two Sets of Data

Now, I will explain how to make a line graph in Excel with two sets of data. Let’s see the steps.


Step-01: Inserting Chart to Make a Line Graph with Two Sets of Data

In this 1st step, I will insert the chart into the worksheet.

  • Firstly, go to the Insert tab.
  • Secondly, click on Insert Scatter or Bubble Chart from the Charts option.

3 Steps to Make A Line Graph in Excel with Two Sets of Data

Now, you will see a drop-down menu.

  • After that, select Scatter with Straight Lines.

3 Steps to Make A Line Graph in Excel with Two Sets of Data

Finally, you will see that you have inserted your chart into the worksheet.

3 Steps to Make A Line Graph in Excel with Two Sets of Data

Read More: How to Make a Single Line Graph in Excel


Step-02: Adding Two Sets of Data in Line Graph

After inserting the chart I will add the two sets of data into the line graph.

  • Firstly, select the Chart.
  • Secondly, go to the Chart Design tab.
  • Thirdly, select the Select Data option.

Adding Two Sets of Data in Line Graph

Now, a dialog box named Select Data Source will appear on the screen. You can add data for your line graph here.

  • To begin with, select Add.

Here, you will get a new dialog box to add your data to the chart.

  • Firstly, select the marked button to add the Series name.

Adding Two Sets of Data in Line Graph

  • Secondly, select the range for your Series name.
  • After that, click on the marked button to add this to your Edit Series.

You will see that your Series name is added to your Edit Series.

  • Now, select the marked button like before to add Series X values.

  • Next, select the range for Series X values.
  • Finally, select the marked button to add the value to your Edit Series.

Now, you will have to add Series Y values.

  • Firstly, select the marked button to add Series Y values.

Adding Two Sets of Data in Line Graph

  • Secondly, select the range for Series Y values.
  • Next, select the marked button and your Series Y values will be added to your Edit Series.

Now, you will see that all the values from your first set of data are added to your Edit Series.

  • Finally, select OK.

Adding Two Sets of Data in Line Graph

Here, you will see that the line graph for your first set of data is showing.

In the same way, you can select your 2nd set of data for the line graph.

  • Firstly, select Add from the Select Data Source dialog box.

Adding Two Sets of Data in Line Graph

  • Secondly, select the range for the Series name.
  • Thirdly, select the range for Series X values.
  • Next, select the range for Series Y values.
  • After that, Select OK, and your 2nd set of data will be added.

  • Finally, select OK on the Select Data Source dialog box to get your line graph.

Adding Two Sets of Data in Line Graph

Now, you will see that you have got your line graph for your two sets of data.

Adding Two Sets of Data in Line Graph

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


Step-03: Formatting Line Graph with Two Sets of Data

After getting the graph you can Format it as you want.

  • Firstly, go to Chart Styles.
  • Secondly, select Styles.
  • After that, you can select any chart format from there. Here, I have selected the marked format in the image below but you can select any other design you like.

Formatting Line Graph

You can also change the colors of the graph.

  • Firstly, go to the Chart Styles option.
  • Secondly, select Color.
  • After that, select the color you like. Here, I selected the marked color in the image.

You can also add Chart Elements.

  • Firstly, go to Chart Elements.
  • After that, select the elements that you want in your line graph. Here, I selected Axis Titles, Chart Titles, and Legend.

How to Make A Line Graph in Excel with Two Sets of Data

Now, you can edit the Axis Titles and Chart Titles according to your dataset. In the image below, you can see that I have edited mine.

Now, you will see the desired line graph in Excel with two sets of data.

How to Make A Line Graph in Excel with Two Sets of Data


Things to Remember

  • You have to be careful while selecting the range for your chart otherwise the graph won’t show the correct result.

Practice Section

Here, I have provided a practice sheet for you to practice.

How to Make A Line Graph in Excel with Two Sets of Data


Download Practice Workbook


Conclusion

In this article, I have shown how to make a line graph in Excel with two sets of data. I hope it was clear to you. I recommend you practice to get perfection. Last but not least if you have any questions please let me know in the comment section below.


Related Articles


<< Go Back To Line Graph in Excel | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mashhura Jahan
Mashhura Jahan

Mashhura Jahan, BSc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology, invested 1.5 years at ExcelDemy. In roles like Excel & VBA Content Developer, Excel Charts, and Dashboard course trainer, she wrote 90+ articles. She was previously part of the forum support team and a junior software analyst on the Excel Add-in project. With interests spanning Excel, VBA, Power Query, Python, Data Science, and Software Development, Mashhura brings a diverse skill set to her... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo