Grouping in bar chart

[#1]

Hi Guys,

I am stuck here...Please help me with the below mentioned query.

I have a table

Country	Type	Points
Mumbai	A	24.0
Mumbai	B	16.6
Mumbai	C	18.1
Mumbai	D	26.8
Mumbai	E	34.7
Mumbai	F	21.4
New york	A	25.3
New york	B	23.8
New york	C	29.0
New york	D
New york	E	42.1
New york	F	25.7

So i need to create a bar chart which should look like this

I have following challenges:

1. I need the bars to be in group, i.e first mumbai and new york, which is possible, but i am getting all in different color bars identified by the types.

2. Between the two group sets of bars, i need a space in between, which i got here as this is taken from excel.

3. By any chance can i make a flip option, where i can select only mumbai or new york and its data should appear.

Thanks in advance!

Regards,

Kuldeep

[#2]

Thanks Andrew i got it now. Thanks for your help.

Just one small question, i wanted to ask you, can i change the size of labels i.e.A,B,C,D,E,F in the chart?

Regards,

Kuldeep

[#3]

Thanks all.

Your suggestions and solutions were very helpful to me.

Regards,

Kuldeep

[awhitfield]

No Problem, use the Settings on the dimension Axis, on the Axes tab, font etc,,

Andy

[#5]

Hi

Please check this QV file

[#6]

Thanks Navven