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