How to Combine Two Graphs in Excel (2 Methods)

Quite frequently we insert graphs for a certain dataset in our Excel worksheet. Graphs help us to analyze our progress or productivity. It can also provide us with a clear comparison between certain figures. But, for this comparison purpose and also to analyze similar sets of data side by side, we need to combine two graphs. In this article, we’ll show you the simple ways to Combine Two Graphs in Excel.


Download Practice Workbook

To practice by yourself, download the following workbook.


Dataset Introduction

To illustrate, I’m going to use a sample dataset as an example. For instance, the following dataset represents the Salesman, Net Sales, and Target of a company. Here, our first graph will be based on the Salesman and Target. And the other one will be on the Salesman and the Net Sales.

how to combine two graphs in excel


2 Methods to Combine Two Graphs in Excel

1. Insert Combo Chart for Combining Two Graphs in Excel

1.1 Create Two Graphs

Excel provides various Chart Types by default. Line charts, Column charts, etc. are among them. We insert them according to our requirements. But, there is another special chart named Combo Chart. This is basically for combining multiple data ranges and is very useful as we can edit chart type for each series range. In our first method, we’ll use this Combo Chart to Combine Two Graphs in Excel and the plottings will be on the Principal axis. But first, we’ll show you the process for creating the two graphs: Target vs Salesman and Net Sales vs Salesman. Therefore, follow the steps below to perform all the tasks.

STEPS:

  • First, select the ranges B5:B10 and D5:D10 simultaneously.

Insert Combo Chart for Combining Two Graphs in Excel

  • Then, select the 2-D Line graph from the Charts group under the Insert tab.
  • Here, you can select any other graph type from the Charts group.

Insert Combo Chart for Combining Two Graphs in Excel

  • As a result, you’ll get your first graph.

Insert Combo Chart for Combining Two Graphs in Excel

  • Now, select the ranges B5:B10 and C5:C10.

Insert Combo Chart for Combining Two Graphs in Excel

  • After that, under the Insert tab and from the Charts group, select a 2-D Line graph or any other type you like.

Insert Combo Chart for Combining Two Graphs in Excel

  • Consequently, you’ll get your second graph.

Insert Combo Chart for Combining Two Graphs in Excel


1.2 Principal Axis

But, our mission is to combine these two graphs. Hence, follow the further process given below to combine the graphs.

STEPS:

  • Firstly, select all the data ranges (B5:D10).

Insert Combo Chart for Combining Two Graphs in Excel

  • Then, from the Insert tab, select the Drop-down icon in the Charts group.

Insert Combo Chart for Combining Two Graphs in Excel

  • As a result, the Insert Chart dialog box will pop out.
  • Here, select Combo which you’ll find in the All Charts tab.
  • After that, select Line as the Chart Type for both Series1 and Series2.
  • Next, press OK.

Insert Combo Chart for Combining Two Graphs in Excel

  • Hence, you’ll get the combined graph.
  • Now, select the graph and right-click on the mouse to set the series names.
  • Click Select Data.

Insert Combo Chart for Combining Two Graphs in Excel

  • Consequently, a dialog box will pop out.
  • Select Series1 and press Edit.

Insert Combo Chart for Combining Two Graphs in Excel

  • As a result, a new dialog box will pop out. Here, type Net Sales in the Series name and press OK.

NOTE: The Series values are C5:C10, so this is the Net Sales series.

  • Again, select Series2 and press Edit.

  • Type Target in the Series name and press OK.

NOTE: The Series values are D5:D10, so this is the Target series.

  • Press OK for the Select Data Source dialog box.

  • Finally, it’ll return the Combined Graph.


1.3 Secondary Axis

We can also plot the graph on the Secondary Axis. Therefore, follow the steps to plot on both Primary and Secondary axes.

STEPS:

  • Here, check the box of Secondary Axis for the Target series and press OK.

  • Eventually, you’ll get the combined graph on both axes.

NOTE: This is particularly helpful when the number formats are different or the ranges differ greatly from each other.

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


Similar Readings:


2. Combine Two Graphs in Excel with Copy and Paste Operations

The copy and paste operation in Excel makes many tasks easier for us. In this method, we will just use this operation for combining the graphs. We have already shown the process to get the two graphs in our previous method. Now, we will simply copy the first graph and then paste it into another one to get our final result. So, learn the steps below to perform the task.

STEPS:

  • In the beginning, select any graph and right-click on the mouse.
  • Select the Copy option.

Combine Two Graphs in Excel with Copy and Paste Operations

  • After that, select the second graph and right-click on the mouse.
  • Subsequently, select the Paste option.

Combine Two Graphs in Excel with Copy and Paste Operations

  • Therefore, you’ll get the combined graph.
  • Now, we will change the graph title. To do that, select the title.

  • Next, type Combined Graph.
  • At last, you’ll get your desired graph.

Related Content: How to Combine Two Bar Graphs in Excel (5 Ways)


Conclusion

Henceforth, you will be able to Combine Two Graphs in Excel with the above-described methods. Keep using them and let us know if you have any more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Aung

Aung

I'm Aung. Recently I earned my B.Sc. Degree in Electrical and Electronic Engineering. From now on, I will be working in Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo