Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pie chart - Percentages not correct (2003)

    I have a pie chart that displays percentages in the labels. I ran some numbers and the percentage is wrong on the chart. It is showing 51% and it should be 54%. My numbers are 138,181/253,901. The 138181 is typed in and the other is a total of the column.

    Why would the percentage be off?

    Please help.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Pie chart - Percentages not correct (2003)

    Are you plotting all the data that makes up the total? Can we see the workbook?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pie chart - Percentages not correct (2003)

    Could you attach a sanitized copy of the workbook with the chart?

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pie chart - Percentages not correct (2003)

    Ok. Here is the chart.

    Please review and let me know. Thanks so much!
    Attached Files Attached Files

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pie chart - Percentages not correct (2003)

    What exactly caused this, I don't know, but two of the six data labels displayed outdated information. The show category names M'care and Other but you haven't specified a range for the category labels. To correct this:
    - Clear the check boxes in the Data Labels tab, then click OK.
    - Tick the check box(es) again, then click OK.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Pie chart - Percentages not correct (2003)

    Your "others" and M'Care" seem to be manually entered. If you remove the datalabels and readd them it works ok. If you include the "categories" as the "X-Axis in the series then it will display the labels and not numbers (See Attached)
    Steve
    Attached Files Attached Files

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Pie chart - Percentages not correct (2003)

    <hr>What exactly caused this, I don't know.<hr>

    I would speculate (and you probably had the same speculation) that since the "categories" were not part of the range, that someone tried to add them manually. But, changing the label manually will make it completely "text" and no longer linked to the data. Thus when the data would change the labels (being text) do not. Only 2 were manually edited, the others stayed linked to the data and reflect the percentage and the "category number" since the categories were not chosen.

    Steve

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pie chart - Percentages not correct (2003)

    That sounds plausible.

Posting Permissions

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