How to Combine Two Line Graphs in Excel (3 Methods)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will learn how to combine two line graphs in Excel. Generally, we need to combine two graphs in one graph paper to show our analysis perfectly. Excel gives us the opportunity to represent our data with different types of graphs. Here, we will use line graphs and try to combine two line graphs in our Excel worksheet.


What Is a Line Graph in Excel?

Line graphs in Excel are also known as line charts. It is a built-in Excel chart type. The line graphs represent data categories on the horizontal axis and data values on the vertical axis. It can handle more data points than columns or bar charts. There are different types of line graphs in Excel. For example, 2-D, 3-D, Stacked Lines, etc.


When Should We Use Line Graphs?

Line graphs are used to represent trends over time (years, months, and days) or categories. Generally, when you have a large dataset that represents some change or nature of a task, we use line graphs to show the trend. Its presentation is simple. So, people can read it easily. You can also use it when you need to handle both positive and negative values. Again, you can use line graphs for comparison.


How to Combine Two Line Graphs in Excel: 3 Ways

To explain the methods, we will use a dataset that contains information about the sales amount of the first six months of Alex and John. We will try to show their sales over these six months using line graphs.


1. Use Copy-Paste Option to Combine Two Line Graphs in Excel

The Copy-Paste option helps us greatly to combine two line graphs. It is a simple and quick method. In this first method, we will first create two graphs from our dataset and then, we will combine them.

Let’s follow the steps below to learn this method.

STEPS:

  • In the beginning, select Cell B5 to B11.
  • Secondly, press the Ctrl key and select Cell C5 to C11.

Use Copy-Paste Option to Combine Two Line Graphs in Excel

  • Thirdly, go to the Insert tab and select the Insert Line or Area Chart icon.
  • After that, a drop-down menu will appear. Select Line from the drop-down menu.

Use Copy-Paste Option to Combine Two Line Graphs in Excel

  • Now, you will see a line graph in your worksheet like below.

Use Copy-Paste Option to Combine Two Line Graphs in Excel

Here, this graph shows the Sales Amount of Alex on the Y-axis and the Months on the X-axis.

  • Next, you need to select the months again. We have selected Cell B5 to B11.
  • Press Ctrl and select the sales amount of John. Here, we have selected Cell D5 to D11.

Use Copy-Paste Option to Combine Two Line Graphs in Excel

  • Follow the previous steps to show John’s line graph.

Use Copy-Paste Option to Combine Two Line Graphs in Excel

  • After creating the graphs, we will have two separate line graphs in our datasheet.

Use Copy-Paste Option to Combine Two Line Graphs in Excel

  • Here, to combine these two graphs, select a graph with the mouse.
  • To select a graph, put the cursor on the line graph and right-click it. We have selected John’s line graph.

Use Copy-Paste Option to Combine Two Line Graphs in Excel

  • Go to the Home tab and select Copy.

Use Copy-Paste Option to Combine Two Line Graphs in Excel

  • Then, select the first graph.

Use Copy-Paste Option to Combine Two Line Graphs in Excel

  • After selecting the first graph, go to the Home tab again and select Paste.

Use Copy-Paste Option to Combine Two Line Graphs in Excel

  • Finally, you will see two combined line graphs like below.

Use Copy-Paste Option to Combine Two Line Graphs in Excel

  • You can change the Chart Title and add Legends to display the graphs properly.

Use Copy-Paste Option to Combine Two Line Graphs in Excel


2. Combine Two Line Graphs in Excel Using Insert Tab

We can use the Insert tab to combine two line graphs in Excel. This method will not combine two separate line graphs. In this method, we will combine two line graphs directly in one graph paper from the dataset.

Let’s pay attention to the steps below to know more.

STEPS:

  • In the first place, select the cells that you want to represent with line graphs. We have selected Cell B5 to D11.

Combine Two Line Graphs in Excel Using Insert Tab

  • After that, go to the Insert tab and select the Charts dialog icon. It will open the Insert Chart window.

Combine Two Line Graphs in Excel Using Insert Tab

  • Now, select All Charts and then, select Combo.
  • Make sure the Chart Type is Line.

Combine Two Line Graphs in Excel Using Insert Tab

  • Finally, click OK to see results like below.

Combine Two Line Graphs in Excel Using Insert Tab

  • To change the title, click on the Chart Title and rename it.

Combine Two Line Graphs in Excel Using Insert Tab

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


3. Combine a Line with an Existing Line Graph in Excel

In this last method, we will combine a line graph with an existing line graph. To explain this method, we will use a dataset that contains information about the Sales Amount of Alex over the first six months and we have a line graph of those data points. We will add the Sales Amount of John to this dataset and then combine the two line graphs.

Combine a Line with an Existing Line Graph in Excel

Let’s observe the steps below to learn this technique.

STEPS:

  • Firstly, enter the data of the Sales Amount of John  in your dataset.

  • Secondly, go to the existing line graph and right-click on it.
  • A drop-down menu will appear. Select ‘Select Data’ from the drop-down menu.

  • After that, the ‘Select Data Source’ window will occur.

  • Next, you need to select all cells from your dataset including the Sales Amount of John

  • After selecting all cells, you will see an entry named John in Legend Entries.

  • Finally, click OK to see results like below.

  • In conclusion, select the graph and a plus icon will appear at the left-top of the graph. You can change or add different items to the graph by clicking the plus icon.

  • We have changed the title and added legends to our graph using the plus icon.

Read More: How to Combine Bar and Line Graph in Excel


Things to Remember

There are different types of graphs in Excel. The line graph is often used when the data has text values along the X-axis and numeric values along the Y-axis. Here, text values mean evenly spaced time labels like days, months, or years. If the data contains only numeric values, then it is better to use scatter graphs.


Download Practice Book

Download the practice book here.


Conclusion

We have discussed 3 easy and quick methods to combine two line graphs in Excel. The Copy-Paste option is the easiest to use. Moreover, we have also demonstrated the way to create line graphs in the first method. You can also use this for multiple line graphs. Furthermore, we have added the practice book at the beginning of the article. You can also download and exercise the practice book. Last of all, if you have any queries or suggestions, feel free to ask in the comment section below.


Related Articles


<< Go Back To Line Graph in Excel | Excel ChartsLearn 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.
Mursalin Ibne Salehin
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo