Advanced Pie Chart Question

[lisamy6]

I have a Pie Chart that shows simply the percentage of North and South Court cases...within each category, I would like to show what percentage is for ages 0-5 and 6+... For example, 69% of Pie is South cases - of the 69% I would like to show that 52% are age 0-5 and 48% are 6+....can this be done?

 

[Mike86]

Add a doughnut chart to the exterior of the pie? Alternatively, use the age specific numbers to make the interior pie and then use the doughnut for the summation.

 

[lisamy6]

THanks Mike86....I'm struggling with this process....I want to specifically indicate and represent the age breakdown in the South and the North respective to their part of the summation (and I want this age breakdown to remain within the part of the pie or doughnut that it represents)

 

[Luke M]

Hi Lisa,

Here's an example of showing the two charts. I've colored the age slices shades of the region color.

 

[lisamy6]

OMG - Luke that is exactly what I want to do!!! Thank you so much!