At first it seems relatively easy to setup. After all, column charts are one of the most used charts in Excel. But once you start to set it up, you realize that in Excel, you can either set up a clustered column chart OR, a stacked column chart – but there is no standard graph, that’s both clustered and stacked at the same time.
One relatively easy way to get the job done is to use both the primary and secondary Y-axis. One problem you’ll run into though, is that they will likely have a different minimum and maximum which will show the wrong visualization. You need to ensure that both the primary and secondary y-axis have the same min and max in a dynamic way (without manually fixing these values). I show you the trick on how you can set this up.
Watch the steps in this video:
Feel free to Download the Workbook HERE.
The new Excel Dashboards course is here!
Now available on Udemy
Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.