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

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.

Now, you will see a drop-down menu.

• After that, select Scatter with Straight Lines.

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

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.

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.

• Secondly, select the range for your Series name.
• After that, click on the marked button to add this 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.

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

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.

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

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

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

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.

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.

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

## 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, 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

Advanced Excel Exercises with Solutions PDF