How to create a Cluster columns Chart with stacked colums?
I have been wondering for a long time how to create a chart that has a bunch of variables and is presented in Cluster Columns graph formating, but at the same time the main variables on the grahp are split into sub categories using stacked column graph formating.
I tend not to use this too often because I have not found a way to do it in a single chart all together. What I usually do "IF I HAVE TO" is to combine to graphs and start playing with the formating until it looks like a single chart. The problem is that it is very time consiuming and to update is also very time consuming.
Here is and example of the problem I face, and the solution I use.
Thanks for you help!
Video Tutorials / Excel Dashboards Reports