How to Create a Combo Chart

Possible Usage Scenarios

Combo charts in Excel allow you to take advantage of this option because you can easily combine two or more chart types to make your data understandable. Combo charts are helpful when your data contains multiple kinds of values, including price and volume. Moreover, combo charts are appropriate when your data numbers vary widely from series to series.

Now we will create a column‑line combo chart. We will first create a column chart, and then modify the series type to line to achieve this combo chart.

Combo chart

After running the code below, you will see the combo chart as shown below.

Sample Code

The following sample code loads the sample Excel file and generates the output Excel file.