I have a Bar chart which have TWO Dimensions and three expression.
Even I have selected chart type is BAR chart and subtype is grouped even after that after adding a SECOND Dimension it automatically converted to STACKED chart.
when you will have more than one dimension in bar chart, it will automatically converted to Stacked Bar Chart..
remove one dimension you will see grouped, but with two, stacked...auto...
A bar chart with more than 1 dimension will be "Stacked" irrespective of whether you have selected "Grouped" or "Stacked".
It will work with 1 dimension and 2 or more expressions or vice versa.
Hope this helps!
Thanks for the quick reply.
You are right. but in normal EXCEL or Chart controls it wouldn't be like that.
Retrieving data ...