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]

[awhitfield · Accepted solution]

Hi Kuldeep,

see the attached example

Andy

[#4]

see attached

[#5]

Friends,

Cant see the attachments

[#6]

Are you using personal edition or a full license of QV?

[#7]

Full licensed version

[ashwanin]

I think you are opening this thread from inbox or notification. 

Click on the Subject : Grouping in bar chart and then check, if you are not able to see the attachment. Because attachment is there.

[#9]

Oh yes, i am sorry folks..will check and get back to you...Thanks!

[#10]

Hello Kuldeep,

You can do the following way. You can use Alerts for Text/Button objects.basedon the button selection you can show the Expressions on Chart layout.usethe conditions on Expressions.

I hope this idea will help you.

Let me know if you need any help.

Thanks

San