Combination Chart

 

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.

Select Data in Excel

2. On the Insert tab, in the Charts group, click the Combo symbol.

Insert Combo Chart

3. Click Create Custom Combo Chart.

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.

Insert Combination Chart

7. Click OK.

Result:

Combination Chart in Excel

Previous articleCalculated Field/Item in a Pivot Table – Easy Excel
Next articleCount Cells with Text in Excel