Sub coloring pie charts

I have a dataset like the one below: (The &-signs means new cell)

Age & Women & Men
0-30 & 7 & 2
31-60 & 3 & 2
61+ & 5 & 1
Total & 15 & 5

I want to draw a pie chart with two pieces. One representing the share of women (75%), and one representing the share of men (25%) in the whole sample. Then I want the individual pieces to be coloured based on the age intervalls. For example, in the piece representing the men there should be three areas with the proportions 40, 40, 20.

How do I proceed?

Sincerely
Hank

If I understood what you want it to look like in the end, you're going to need to rearrange your data.

0-30 M 2
0-30 F 7
31-60 M 2
310-60 F 3

etc.etc... then run the pie.

Select the re arranged data in D7:F15 and create a donut chart.
Select the first series, age break down, and change chart type to pie.

Apply data labels using Category. Format slices to match Gender colouration.