Pie of Pie chart with percentages (Excel 2008)

[coreyarms]

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?

 

[Sjodom]

Did you ever figure out how to accomplish this? I am having the same problem.

 

[coreyarms]

Never figured it out, I did it manually. I made two separate pie charts and then made them look like a pie of pie using photoshop. It was for a presentation so I didn't need the chart to be functional or connected to excel or anything, just a visual aid.

 

[Sjodom]

Thanks. Still working on it myself. Had to switch to bar charts for now...