The issue is a result of how Excel creates pie chart percentages i.e. it
forces the percentages to equal exactly 100%. Please refer to the link below
for details.

http://support.microsoft.com/kb/214033

To get around this, consider downloading John Walkenbach's Chart Tools
add-in which is available via the link below.

http://j-walk.com/ss/excel/files/charttools.htm

Once you have the add-in set up, use the Data Labels feature to apply the
data from the spreadsheet directly to the pie chart labels.

--
John Mansfield
http://cellmatrix.net





"Niki" wrote:

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......