The data label option for percentages displays the percentage of each wedges
part of the circle. If you have three percentages in the sheet, each 25%,
selecting the percentages option will not show 25%, it will show 33 or 34%.
If instead, you choose the values option, you will see 25% for each.

There are so many better options than pie charts. Use a pareto chart (a
column chart with items sorted from high to low), with custom labels if need
be.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Niki" wrote in message
...
I am trying to create a pie chart that shows the percentages of each type
of
monthly expenses for a household. I have set up a spreadsheet that
contains
the category name, the amount of each bill and the percentage that each
bill
represents of the monthly income. The problem is that when I create the
chart, the percentages shown in the pie chart are different than the
percentages shown on the spreadsheet. I know that the chart is updating
automatically from the numbers on the spreadsheet because when I change
any
of the info on the spreadsheet the percentages on the chart change also
but
they still aren't right.

I have tried to create the chart by including the percentages that have
been
figured in the spreadsheet and I have tried to create the chart by not
including the percentages and it doesn't seem to have any effect on what
the
chart come up with in regard to the percentages it shows.

Is there some kind of formatting that I'm doing wrong or anything.... I
haven't done much with charts but I can usually figure most things out by
playing around with it but this one is driving me crazy.

Any help would be much appreciated......