How to Create a Combination (Combo) Chart in Excel
There are various charts in Excel, which can be used to create an Excel Combination chart. For example, we can use Bar charts and Line Charts, Column Charts and Line charts, etc. Follow the below steps to create a Combination chart in Excel:
Step 1: Insert the data in the cells. After insertion, select the rows and columns by dragging the cursor.
Step 2: Now click on Insert Tab from the top of the Excel window and then select Insert Column or Bar Chart. From the pop-down menu select the first “2-D Column”.
Step 3: To add a combination chart :
Select the Chart> Design > Change chart Type.
Change Chart Type.” width=”inherit” height=”inherit”>
Another way is to right-click on the chart and select “Chart Type”.
Step 4: The Chart Type window opens. Now go to the “Combo” option and check the “Secondary Axis” box for the “Percentage of Students Enrolled” column. This will add the secondary axis in the original chart and will separate the two charts. This will result in better visualization for analysis purposes.
The combination charts are ready. The secondary axis is for the “Percentage of Students Enrolled”. The modifications can be performed in this secondary axis using the Format Axis window on the right corner of Excel.
Step 5: You can format the above combo chart by adding various “Chart Styles”, and suitable “Axis Titles” in all three axes. Refer to the image shown below :
Now, we can also change the type of the second chart. For that right-click on the chart and open the “Chart Type” window. In our case, we have selected a Stacked Line with markers for the Percentage of Students Enrolled line chart.
We can infer from the above chart that in the year 2019, the percentage of students who enrolled in online paid courses is relatively less but in 2020 more students have enrolled in paid courses than free content on YouTube.
Combination Charts in Excel
Sometimes while dealing with hierarchical data we need to combine two or more various chart types into a single chart for better visualization and analysis. These are known as “Combination charts” in Excel.
In this article, we are going to see how to make combination charts from a set of two different charts in Excel using the example shown below.
Contact Us