Urgent HELP in PIE charts

[afzalzada]

Dears,

There is a question with the below data. thanks
Q: Do a Pie graph showing the total male and female breakdown by age and province.
PieGraph.xlsx

[Pepe Le Mokko]

Hi
is this some kind of homework?

[6StringJazzer]

You can't have a graph if you don't have data. Where does this question come from?

[afzalzada]

You can't have a graph if you don't have data. Where does this question come from?

Attached please find the data. thanks

[afzalzada]

Hi
is this some kind of homework?

Not homework but a question which will be in exam for a job :P

[6StringJazzer]

I think you don't understand what the question is asking or what such a pie chart would even look like. Your data lists a bunch of individuals but to graph that data in a pie chart, you need to segregate them into groups. It's obvious that male/female is one grouping, province is another grouping. But it is unclear how you want to graph age. There are two ways to do it. One is if you have a very large amount of data, you have a pie slice for each age. But then you will have dozens and dozens of slices and such a pie chart is fairly worthless. Or you could group the ages into a few groups (0-17, 18-25, 26-40, 40-90).