How to Create Combination Chart in Excel
A combo chart or combination chart is a single chart consisting of more than one series of different chart types. To be able to use a combo chart, it needs at least two sets of data series. The figure below shows a chart with 5 data series.
How is it done
The easiest way to create a combo chart in Excel is to insert a normal chart. It can be done by selecting your data set first (at least 3 columns of data to create a double series chart), then go to Insert > Charts > Select any chart type.
Once you have the chart displayed, simply select it then right click, a small window will pop out with a couple of options, select 'Change Chart Type'.
A new Excel window will come out then choose 'Combo' type chart, all series of data will be populated at the bottom part of the window. The last step is to choose the correct type of chart for each data series. In the example below, we have 5 data series and we assigned 5 different chart types (Area Chart, Column Chart, Line Chart, XY Scatter and Pie Chart).
Excelcrib was founded in November 2017 by Garry, a Microsoft® Office Excel® (MS Excel) enthusiast with background in engineering. He's been using MS Excel for more than 15 years in practice with specialty in VBA.