I'm trying to create a pie of pie chart for my data. The problem I'm running in to is that all the data are percentages, and the 2nd pie needs to add up to it's own 100%. The first pie chart is segmenting a population into 4 categories, and then within one of the categories I want to display the percentage of males and females. My data is as such:
Type - Percentage of population
No Response - 14.8%
Disinterested - 22.5%
Out of Touch - 29.4%
Technos - 33.3%
Then within the Technos category, I want to display:
Males - 58.3%
Females - 41.7%
I'm able to get it to work if I scale down the percentages of Males and Females to add up to 33.3 and delete the Technos category, but I'd like to keep the real percentages if possible.
Is this possible?
Type - Percentage of population
No Response - 14.8%
Disinterested - 22.5%
Out of Touch - 29.4%
Technos - 33.3%
Then within the Technos category, I want to display:
Males - 58.3%
Females - 41.7%
I'm able to get it to work if I scale down the percentages of Males and Females to add up to 33.3 and delete the Technos category, but I'd like to keep the real percentages if possible.
Is this possible?