Mashhura Jahan
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.
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 Line Graph in Excel with Multiple Lines (4 Easy Ways)
Similar Readings
- How to Add a Vertical Dotted Line in Excel Graph (3 Easy Methods)
- Draw Target Line in Excel Graph (with Easy Steps)
- How to Draw a Horizontal Line in Excel Graph (2 Easy Ways)
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.
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.
- 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.
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.
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.
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.
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.
