A combo (or combination chart) is a chart that plots multiple sets of data using two different chart types. A typical combo chart uses a line and a column.
Despite being out of support for several years, Excel 2010 is still in use in many organisations, however, unlike Excel 2013 and 2016, Excel 2010 does not offer combo chart as one of the built-in chart types. This tutorial shows how to create a combo chart in Excel 2010.
Select the Cells
Select the cells containing the headings and numbers to be included in the chart
Insert a Column Chart
- Click the Insert tab on the Ribbon
- Click Column
- Click the type of column chart required – in this example 2-D Column has been selected
The Column Chart
Change One of the Bars (to a Line)
- Right click on one of the bars that represent the series to be changed (to a line) and select Change Series Chart Type from the menu
- Select the type of chart required for this data series
- Click OK
Display the Scale for the Line on Secondary Axis (Optional)
- In the chart, right click the line
- Select Format Data Series
- In the Series Options, select Secondary Axis
