A combination chart in Excel displays two types of charts (such as column and row) in the same chart. They are used to display different types of information in a single chart, such as: B. Actual values for a destination.
This article shows how to create a combo chart that follows the same axis, and mixed types of information display data in a single chart on a different axis.
Inserting a Combination Chart with a Single Axis
In the first example, we will create a combination chart to show the monthly revenue for a target using the following example data. [1
You can see that the target value is the same every month. The result shows the data as a straight line.
First, select the range of cells that you want to plot on a graph – A1: C13 in this example. Then click Insert> Insert Combination Chart. Select "Clustered Column – Line".
The combination diagram is inserted with both the column and the line on the same axis. As simple as that!
You can now continue to improve the diagram, such as: For example, change the chart title. Click the chart title box and begin typing to replace the words "chart title" with something more useful. As you type, the text appears in the formula bar above.
Press Enter, and Excel saves the typed text as a chart title. 
Inserting Combination Chart with Two Axes
Use the sample data shown below to create a combination chart to show the monthly earnings and the ad budget in the same chart. 
Select range A1: C13. Click Insert> Combination Chart. Select the Clustered Column – Line on Secondary Axis diagram.
The inserted chart looks like this.
Changing an Existing Chart to a Combination Chart
We looked at two examples of how to create a combination chart from worksheet data, but it may also be useful to edit an existing chart.
Below is a grouped column chart created from The Revenue and Ad budget data.
The chart has an axis and you can barely see the ad budget columns in the chart. Change this to a combination chart by creating a secondary axis for the ad budget data and changing the chart type to a line.
First, right-click on the data series you want to change (in this example, the ad budget). , Next, select "Modify Row Chart Type".
Now select the Secondary Axis check box for the data series for which you want to create an axis. In the Chart Type list, select Line for this series.
The chart changes to a combination chart.
Then you can make further improvements to the Combination Diagram. For example, edit the chart title or label the axis.