Subject Line
Combo offer for charts
Overview
Sometimes you may have to show different type of information on a single chart. You will have to combine two or more charts in a single chart. We can use Combo chart in excel to create such charts. It is like a combo offer where you can enjoy the benefits of two offers in one offer.
Working
Let’s understand the working with an example.
We have (Figure 1: Sales data of Smart Phone) from the year 2011 till 2019.
You have to create a chart showing the Sales and profit made by Smart Phone each year in one single chart.
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-1.jpg)
Figure 1: Sales data of Smart Phone
Step 1: Select the Sales table A1 to F10
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-2.jpg)
Step 2: Click on INSERT tab
Step 3: Click on Recommended Charts
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-3.jpg)
Step 4: Insert Chart dialog box appears
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-4.jpg)
Step 5: Click on All Charts tab
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-5.jpg)
Step 6: Click on Combo
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-6.jpg)
Step 7: Combo Chart appears
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-7.jpg)
Step 8: Go to Design
Step 9: Click on Select Data
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-8.jpg)
Step 10: Select Data Source dialog box appears
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-9.jpg)
Step 11: Select Year from Legend Entries (Series) and click on Remove button
Step 12: Select Price from Legend Entries (Series) and click on Remove button
Step 13: Select Quantity from Legend Entries (Series) and click on Remove button
Step 14: From Horizontal (Category) Axis Labels click on Edit
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-10.jpg)
Step 15: Select the Year from B2 to B10
Step 16: Click on OK
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-11.jpg)
Step 17: Click on OK
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-12.jpg)
Step 18: Go to Design Tab
Step 19: Click on Change Chart type
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-13.jpg)
Step 20: Change Chart Type dialog box appears
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-14.jpg)
Step 21: Click on All Charts
Step 22: Select Clustered Column chart type for Sales Amount.
Step 23: Select Line with Markers chart type for Profit
Step 24: Select the Secondary Axis tick box for Profit
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-15.jpg)
Step 25: Select Style 6 from Chart Styles from Design tab
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-16.jpg)
Step 26: Create a sheet named Chart
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-17.jpg)
Step 27: Combination chart is prepared
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-18.jpg)
Step 28: Go to Design tab
Step 29: Click on Move Chart tab
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-19.jpg)
Step 30: Move Chart Dialog Box appears
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-20.jpg)
Step 31: Select Chart in Object in dropdown
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-21.jpg)
Step 32: Combination chart moves to Chart sheet
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/10/C-22.jpg)
Scope of Usage
- Can be used to combine two charts
- Can be used for better analysis
- Can be used to represent more values in a single chart
Can be used for clear data points