Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Posts
    13

    Unhappy Unanswered: Pie Chart question

    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

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy.

    Can you attach a sample file to work with?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jan 2005
    Posts
    13

    Source file sample for pie chart

    Shades,

    Attached please find my excel file
    Attached Files Attached Files

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    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.
    Attached Files Attached Files
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •