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.
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
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.
- First, select the ranges B5:B10 and D5:D10 simultaneously.
- 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.
- As a result, you’ll get your first graph.
- Now, select the ranges B5:B10 and C5:C10.
- After that, under the Insert tab and from the Charts group, select a 2-D Line graph or any other type you like.
- Consequently, you’ll get your second graph.
Read More: How to Create a Combination Chart 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.
- Firstly, select all the data ranges (B5:D10).
- Then, from the Insert tab, select the Drop-down icon in the Charts group.
- 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.
- 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.
- Consequently, a dialog box will pop out.
- Select Series1 and press Edit.
- 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.
Read More: How to Draw Target Line in Excel 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.
- 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.
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.
- In the beginning, select any graph and right-click on the mouse.
- Select the Copy option.
- After that, select the second graph and right-click on the mouse.
- Subsequently, select the Paste option.
- 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.
Download Practice Workbook
To practice by yourself, download the following workbook.
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.