How to Create Combination Chart In Excel

Oct 24, 2020 • edited Oct 25, 2020

How to Create 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.

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

#Tutorial#How To#Data Analysis#Charts

How to create Color Scales In Excel

How to Create Data Form In Excel