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.
Figure 1: Sales data of Smart Phone
Step 1: Select the Sales table A1 to F10
Step 2: Click on INSERT tab
Step 3: Click on Recommended Charts
Step 4: Insert Chart dialog box appears
Step 5: Click on All Charts tab
Step 6: Click on Combo
Step 7: Combo Chart appears
Step 8: Go to Design
Step 9: Click on Select Data
Step 10: Select Data Source dialog box appears
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
Step 15: Select the Year from B2 to B10
Step 16: Click on OK
Step 17: Click on OK
Step 18: Go to Design Tab
Step 19: Click on Change Chart type
Step 20: Change Chart Type dialog box appears
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
Step 25: Select Style 6 from Chart Styles from Design tab Profit
Step 26: Create a sheet named Chart
Step 27: Combination chart is prepared
Step 28: Go to Design tab
Step 29: Click on Move Chart tab
Step 30: Move Chart Dialog Box appears
Step 31: Select Chart in Object in dropdown
Step 32: Combination chart moves to Chart sheet
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