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

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

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

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.

• Follow the previous steps to show Johnâ€™s line graph.

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

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

• Go to the Home tab and selectÂ Copy.

• Then, select the first graph.

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

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

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

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

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

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

• Finally, click OK to see results like below.

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

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.

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.

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

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

Advanced Excel Exercises with Solutions PDF