Hey everybody. In this tutorial I’m gonna show you how to create a Clustered Stacked Column Chart in Excel. It’s a nice combo chart that Excel doesn’t offer in the default charts.
In this data table we have two courses with their Income and Expenses, for each of the following categories: e-learning, YouTube, Webinars and Podcast. These 4 are gonna be our Legend. So the first and most important step is to set up your Data correctly. Income and Expenses are our multi-level axis labels.
Now highlight our Data Range, from A2 to F6, go to Insert Tab, press the column chart and pick the stacked column chart. It’s not yet the chart we want, as you can see.
Click on the chart and from Design Tab find the Switch Row/Column button on your right and click on it. Excel has created a stacked column chart with the combination of a Column Chart. Also Excel made two groups of Data, Course 1 and course 2. The vertical axis shows the totals of Income and Expenses, for each course.
Highlight for example the data range from C3 to F3, it’s the income of Course 1, and look down there at the sum. Now right click anyone of these series and from Format Data Series, change the Gap Width to 100%.
If you want, you can change the title of the chart and move the legend to the right. Nice!
It’s also works for Bar Charts, so if you want you can go to Design Ribbon and change the chart type to a Stacked Bar Chart.
If you have any questions, post a comment and I’ll answer it as soon as possible.
You can also download the Excel sample File
If you want to learn how to make amazing Dynamic Excel Charts, Dashboards and Pivot Charts in a few weeks, take our Udemy Course for only $25 !! (original price: $199 - 87% OFF!)
Latest from Mellon Training
- How to distribute your dashboard
- How to use Symbols and Arrows in Excel Formulas and Insert them into our Chart
- How to Import-Convert Data from Word Document into Excel worksheet
- How to generate Random Decimal Numbers between 0 and 1
- Blocking a user to interact outside a specific range – ScrollArea Property