How to create a clustered column chart
After we’ve seen what a simple column chart looks like, it’s time we move forward.
There are many variations to the column chart. And each of them helps with different types of comparisons.
The first variation that we are going to see here is a clustered column chart. As the name suggests, a clustered column chart is where multiple columns are clustered together 🎀
A clustered column chart is used when we have multiple categories and sub-categories of data.
Let’s see this through an example below.
Here, we have the numbers of employees of four different companies over two years (2021 & 2022).
This means we want to compare the number of employees:
- in all four companies (Category)
- in the years 2019 and 2020 (Sub-category)
So, let’s make a clustered chart out of it. Here’s how to do it:
- Select the data to be plotted as a chart.
- Go to the Insert Tab > Column Chart Icon.
- Choose a clustered column chart. You may choose a 2D or a 3D chart.
We are going with a 2D chart for now.
There it is! Excel makes a clustered column chart out of our dataset 🎯
Note that for each company, we have two columns clustered together.
The blue column represents the year 2021. Whereas the orange column represents the year 2022.
How do we know that? Look at the legends at the bottom of the chart 👀
Looking at the chart we can tell that the biggest change in employees over the two years was seen by Company C.
The orange column (for 2022) in the case of Company C is significantly shorter than the blue column (for 2021).
A similar analysis can be made for the change in employees of each company over the two years. And also for all the companies with each other.
Easy and understandable? Clustered charts are a savior when it comes to complex datasets 🤍