spot_img

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

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