Hi Experts,

I have a table (spreadsheet) with following fields:

ID (char)
Agecat (char)
Gender (char)
Indicator (integer)

ID Agecat Gender Indicator
1 A F 0
2 B F 1
3 A F 1
4 C F 0
5 C F 1
6 B M 0
7 B M 1
8 D M 1
9 C M 0
10 C M 1


1. I need to show a percentage of Gender By Age for those who have an indicator =1.
2. I need this percentage among all other members of the table.
3. I need to represent it in a PIE CHART format with 3 different colors: 1st is for Female, 2nd for Male, third for all other population (with indicator=0)

Could you please give me a hand? I have beaten my head trying to create a pie chart

Thank you in advance,

Katrin

Howdy.

Can you attach a sample file to work with?

Shades,

Attached please find my excel file

I think the percentages can be achieved using a Pivot Table (see Pivot2 on attachment).

The third is a little confusing (for me). Do you want a pie chart for each age group? But maybe the Pivot will give you what you want.