reg obtaining both the grouped and stacked features in a single bar chart

[#1]

Hi,

I have a req for a bar chart which specifies:

-time on x-axis

-three bars/groups for three quantities assume q1,q2,q3

-in turn have to stack the 3 individual bars to represent different locations quantities.

-have location and time dimensions.

please help me to get this view.

thanks in advance.

[#2]

If at all this graph shows up correctly, i think it is gonna look complicated with those two dimensions. A better option for you may be, to make a drill down group of location and date. Then use this group as the dimension, and those three quantities as expression. So that initially it will show the quantities location wise, and on selecting a particular location, it will display time wise, or vice versa.

[#3]

thank you.is there any way that i can acheive the exact view it is needed? can you please suggest.

[#4]

Ok, then i guess you are looking for something like this.

For plotting this thing, all you need to do is, give month and location as dimensions and those 3 quantities as expression.

Also, change the style of the graph.

[#5]

okay.thank you.But i need 3 bars for 3 quantities side by side,then i have to have stacks of different colors within each of the bars indicating different locations.