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

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.


Download Practice Workbook


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

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 Line Graph in Excel with Multiple Lines (4 Easy Ways)


Similar Readings


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 a Double Line Graph in Excel (3 Easy Ways)


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

Read More: How to Make a Single Line Graph in Excel (A Short Way)


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


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. If you like this article then, you can visit ExcelDemy for more articles like this. Last but not least if you have any questions please let me know in the comment section below.


Related Articles

Mashhura

Mashhura

Hey! Welcome to my profile. Right now, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo