What is a Combo Chart in Excel
Combination charts in Excel is a tool that allows you to display multiple types of data on the same chart. These are also called Combo Charts. Combination charts are combinations of two or more different charts in Excel. To combine two charts, we should have two datasets but one common field combined. By combining different chart types, you can present complex datasets in a visually appealing and easy-to-understand manner.
Example: Consider a famous coaching institute that deals with both free content in their YouTube channel and also has their own paid online courses. There are broadly two categories of students in this institute :
- The students who enrolled but are learning from YouTube free video content.
- The students who enrolled in paid online video lectures.
So, the institute asked its Sales Department to make a statistical chart about how many paid courses from a pool of courses that the institute deals with sold from the year 2014 to the year 2020 and also show the percentage of students who have enrolled in the online paid courses only.
Table
| Course Enrollment Stats | ||
|---|---|---|
| Year | Number of Paid Courses sold | Percentage of students enrolled |
| 2014 | 10 | 30% |
| 2015 | 15 | 25% |
| 2016 | 20 | 30% |
| 2017 | 20 | 50% |
| 2018 | 25 | 45% |
| 2019 | 15 | 20% |
| 2020 | 30 | 70% |
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