< Back

Excel: Create Combo Charts

Wed Sep 26, 2018 6:19 pm

Combination Chart





A combination chart is a chart that combines two or more chart types in a single chart.





To create a combination chart you can follow these steps.



  • Your data should be in columns as below.







    Image





  • Select the range of data that you need to include in the chart. Here it is A1:C10.







    Image





  • Go to the Insert tab; in the Charts section, click the Combo symbol.









    Image





  • Click on Create Custom Combo Chart...







    Image





  • The Insert Chart dialog box appears. Here select the type of chart that you need for both data sets







    Image





  • Click on the drop down next to the data field to choose the type of chart that you like.







    Image





  • Click OK. Here is an example of Clustered bar and Line chart.







    Image