How to count the group percentage in Gchart

[ursula]

Hi there,

I wonder if somebody can help me to figure it out of how to code the group percentage in Gchart.

I have 3 groups in one Gchart. for example: first group is US (female , male)

                                                                 second group is AU (female, male)

                                                                 Thirth group is Hawaii (female, male)

I want to code the female and male percentage for US, AU and Hawaii individually, so each group has the total percent of 100%

- percent female and male in US. for example: 60% female and 40% male.

- how many percent female and male in AU. for example 25% female and 75% male

- how many percent female and male in Hawaii. for example 50% female and % male

when I created a Gchart for the 3 group, I got the total 100% for the 3 groups (for example: US (female=10% male=20%), AU(female=20% male=30%) Hawaii(female=10% male=10%)),this is not what I expected.

Please help me to solve the problem.

Thank you,

[AncaTilea]

So,

I believe you will need your group variable to be the US,AU,HAWAII, and then have gender as a subgroup.

[ballardw]

It is helpful to post the code you used when asking questions as you could be very close and only need minor changes or sometimes the data needs to preprocessed.