Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

How to combine 2 or more chart types in a single chart in Excel

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.

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.


Leave a Reply

Your email address will not be published. Required fields are marked *