How to Combine Two Line Graphs in Excel – 3 Methods

What Is a Line Graph in Excel?

The line graphs or line charts represent data categories on the horizontal axis and data values on the vertical axis. They can display more data points than columns or bar charts.


When Should We Use Line Graphs?

Line graphs are used to represent trends over time (years, months, and days) or categories.


How to Combine Two Line Graphs in Excel

This is the sample dataset. To show Alex and John’s sales over the six months:


Method 1 – Use the Copy-Paste Option to Combine Two Line Graphs in Excel

STEPS:

  • Select  B5:B11.
  • Press Ctrl and select C5:C11.

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

  • Go to the Insert tab and select Insert Line or Area Chart.
  • Select Line.

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

  • A line graph will be displayed.

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

The graph shows the Sales Amount of Alex in the Y-axis and the Months in the X-axis.

  • Select the months again: B5:B11.
  • Press Ctrl and select John’s sales amount. Here, D5: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

  • There are two separate line graphs in the datasheet.

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

  • To combine the two graphs, right-click a graph. Here, John’s.

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

  • Select the first graph.

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

  • Go to the Home tab again and select Paste.

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

  • The two combined line graphs will be displayed.

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

  • You can change the Chart Title and add Legends.

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


Method 2 – Combine Two Line Graphs in Excel Using the Insert Tab

STEPS:

  • Select the cells that you want to represent in the line graphs. Here, B5:D11.

Combine Two Line Graphs in Excel Using Insert Tab

  • Go to the Insert tab and select Charts to open the Insert Chart window.

Combine Two Line Graphs in Excel Using Insert Tab

  • Select All Charts and choose Combo.
  • In Chart Type, choose Line.

Combine Two Line Graphs in Excel Using Insert Tab

  • Click OK to see the result.

Combine Two Line Graphs in Excel Using Insert Tab

  • To change the title, click 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


Method 3 – Combine a Line and an Existing Line Graph in Excel

The dataset contains a table and a graph with information about Alex’s Sales Amount over the first six months. Add John’s Sales Amount to this dataset and  combine the two line graphs.

Combine a Line with an Existing Line Graph in Excel

 

STEPS:

  • Enter the data ( John’s Sales Amount).

  • Go to the existing line graph and right-click it.
  • Click ‘Select Data’.

  • The ‘Select Data Source’ window will be displayed.

  • Select all cells in your dataset including John’s Sales Amount.

  • John will be displayed in Legend Entries.

  • Click OK to see the result.

  • Select the graph and click the plus icon. You can change or add different items to the graph.

  • The title was changed and legends were added.

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


Download Practice Book

Download the practice workbook here.


Related Articles


<< Go Back To Line Graph in Excel | Excel ChartsLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
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