Sometimes having just clustered or stacked column charts is not enough. Now, with a magic of combining multiple value axes and stacked columns it's possible to create clusters of stacked columns.
It's a rather simple workaround:
- Create a separate ValueAxis for each separate column. Enable regular stacking for the axes.
- Assign graphs to appropriate "cluster" axes.
- That's it!
Here's a working example:
P.S. and to make things even more cool, you can add non-clustered columns to the mix as well by setting particular graphs stackable property to false.