Combination Chart in Excel
A combination chart is a chart that combines two or more chart types in a single chart.
To create a combination chart, execute the following steps.
1. Select the range A1:C13.
2. On the Insert tab, in the Charts group, click the Combo symbol.
3. Click Create Custom Combo Chart.
The Insert Chart dialog box appears.
4. For the Rainy Days series, choose Clustered Column as the chart type.
5. For the Profit series, choose Line as the chart type.
6. Plot the Profit series on the secondary axis.
7. Click OK.
Result:
If you're new here, welcome to Excel Easy! Join over 1 million monthly Excel learners. You can find popular courses here: Excel Functions and Data Analysis in Excel.
