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

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.


Download Practice Book

Download the practice book here.


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


3 Ways to Combine Two Line Graphs in Excel

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

Read More: How to Combine Graphs in Excel (Step-by-Step Guideline)


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 Combine Graphs with Different X Axis in Excel


Similar Readings:


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 Alex’s sales amount over the first six months and we have a line graph of those data points. We will add John’s sales amount 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 John’s sales amount 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 John’s sales amount.

  • 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 Two Bar Graphs in Excel (5 Ways)


Things to Remember

There are different types of graphs in excel. The line graph is often used when the data has text values along X-axis and numeric values along 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.


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

Mursalin

Mursalin

Hi there! This is Mursalin. I am an Excel and VBA content developer at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo