Hi,
Can any one help me about how to develop a stacked cluster column chart in Xcelsius…
I have 9 metrics to display across 18 month roll out and each metric has a actual and planned values …
So , i think stacked cluster column chart is Apt …
Please Help me with u r suggestions…
meetsaiat 
(BOB member since 2012-05-25)
Hi,
This is possible in very much the same way that you can create a stacked cluster chart in Excel.
E.g if you had 4 metrics that you wanted in clusters two high the following would work by clustering metrics A & B together and C & D together. The blank line is deliberate to split up the columns.
Month Metric A Metic B Metric C Metric D ....
Jan 1 1
- 1 1
-
Feb 1 1
- 1 1
-
Mar 1 1
- 1 1
-
....
You can then assign the range of a stacked chart to the entire range and set data to in columns. Finally set the ‘Marker Gap’ in the appearance tab to 0.
Clusters of any or mixed sizes can be combined. I’ve attached an example.
Hope that all makes sense,
Paul
Stacked Cluster.zip (12.0 KB)
zygorf (BOB member since 2011-11-24)
Hey Paul,
That was really helpful … It worked …
Thanks a ton for u r help …
meetsaiat (BOB member since 2012-05-25)
really helpful! Thanks!
Tiny 
(BOB member since 2004-11-10)