09-18-2013 04:31 PM
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.
09-18-2013 06:06 PM
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.