Press OK for the Select Data Source dialog box.

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

Type Target in the Series name and press OK.

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

Here, type Net Sales in the Series name and press OK. As a result, a new dialog box will pop out.Consequently, a dialog box will pop out.Now, select the graph and right-click on the mouse to set the series names.After that, select Line as the Chart Type for both Series1 and Series2.Here, select Combo which you’ll find in the All Charts tab.As a result, the Insert Chart dialog box will pop out.Then, from the Insert tab, select the Drop-down icon in the Charts group.Firstly, select all the data ranges ( B5:D10).Hence, follow the further process given below to combine the graphs. Consequently, you’ll get your second graph.īut, our mission is to combine these two graphs.After that, under the Insert tab and from the Charts group, select a 2-D Line graph or any other type you like.Now, select the ranges B5:B10 and C5:C10.As a result, you’ll get your first graph.Here, you can select any other graph type from the Charts group.

Then, select the 2-D Line graph from the Charts group under the Insert tab.

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

Therefore, follow the steps below to perform all the tasks. But first, we’ll show you the process for creating the two graphs: Target vs Salesman and Net Sales vs Salesman.

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. This is basically for combining multiple data ranges and is very useful as we can edit chart type for each series range. But, there is another special chart named Combo Chart. We insert them according to our requirements. Insert Combo Chart for Combining Two Graphs in Excel 1.1 Create Two GraphsĮxcel provides various Chart Types by default. And the other one will be on the Salesman and the Net Sales.Ģ Methods to Combine Two Graphs in Excel 1. Here, our first graph will be based on the Salesman and Target. For instance, the following dataset represents the Salesman, Net Sales, and Target of a company. To illustrate, I’m going to use a sample dataset as an example.

How to plot a graph in excel 2010