Hello ,
I need to display 3 year of data (pass vehicles, comm vehicles) on stacked chart.
so I need 3 bars for each quarter for 2014,2013 and 2012 and each bar should have pass vehicles count and comm vehicles count.
is this possible with stacked chart? what other options do I have to diplay all this data in one chart(I cannot go for combinational chart ) Please help!!
swethag (BOB member since 2014-08-06)
Er, why not just have twelve bars? That is, 2012-Q1, 2012-Q2, 2012-Q3, 2012-Q4, 2013-Q1, 2013-Q2, 2013-Q3, etc. You could even label them Q1-2012, Q1-2013, Q1-2014, etc., so that all the bars for a given quarter sort together.
I’m pretty sure that you can’t group the bars by quarter AND have stacked values within the bars.
Lugh (BOB member since 2009-07-16)
Thank you Lugh, but Chart canvas is really small , so I cannot have 12 bars in the chart.
swethag (BOB member since 2014-08-06)
Hi,
You’ll need to use the concept of ‘Small Multiples’. Whereby you use small versions of the same chart next to each other
MultipleStackedCharts.zip (10.0 KB)
cdavies 
(BOB member since 2005-01-28)
Charles,
good idea !!
but I cannot open the sample flash file you have provided, because I am on older verison of Xcelsius
Any how, My users had decided to show 1 year at a time .so I am good for now.
Thank you
swethag (BOB member since 2014-08-06)
Sorry!
XC 2008 SP3 version attached.
MultipleStackedCharts_XC2008.zip (10.0 KB)
cdavies (BOB member since 2005-01-28)