Best 100+ Excel Hacks & Tips with Excel 2016. Take the course for only $10 !!

Arrow up
Arrow down
Menu
How to Create an Excel Clustered Stacked Column (or Bar) Chart in 3 easy steps

How to Create an Excel Clustered Stacked Column (or Bar) Chart in 3 easy steps

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

Thank you!

 

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!)

Last modified onSunday, 13 December 2015 11:51
Rate this item
(3 votes)