Combo Chart (Column + Line) chart can be used to to show two different/same type of data points for multiple categories.
For example if we have employee wise Sales and Sale conversion%.
We can use combo chart here. Sale data can be displayed in columns and Sales conversion can be displayed on line chart at secondary axis.
We will learn how to create combo chart in excel 2010 and 2013 both.
Combo Chart in Excel 2013:
Its quite easy to create combo chart in Excel 2013. below steps to be followed –
- Select data range “A1:C6”
- Go to Insert>>Charts>>Recommended Charts
Choose the first option in recommended charts.
Now the change the Chart title as “Employee wise Sales and Sale Conversion“. Our Combo chart is ready in Excel 2013.
Combo chart in Excel 2010:
To create combo chart in Excel 2010 below steps to be followed:
- Select data range “A1:C6”
- Go to Insert>>Charts>>Line Chart>>Line with Markers
- Select the sales conversion line (orange line)
- Right click on sales conversion line.
- click on Format Data Series.
Select Secondary Axis under Series Option.
- Now select the Sales Line (Blue Line)
- Right click on Sales Line
- Click on Change Chart Type
Select Clustered Column in Change Chart Type window.
Now change the chart layout from Design Tab >> Chart Layouts >> Layout 3
Now change the Chart style.
Select the chart and go to Design Tab >>Chart Styles >>Style 42
Now change the Chart title as “Employee wise Sales and Sale Conversion”
Our combo chart is ready. Please download the Excel file for practice.