Pie chart not displaying % in spreadsheet

[Guest]

The percents on the pie chart are not the percents appearing on the
spreadsheet.
I have typed a list of percents and link to them from the pie chart but the
%s on the pie chart differ from the spreadsheet.

I have a spreadsheet set up for various expenses. The last column is a total
column & the last row is a total. I usually use the total column for my pie
chart. The problem is that sometimes one of the expenses is a negative. I
can't use that it my chart. I don't know how to get around this problem. I've
tried hiding the row, but the %s on the chart are different than the
spreadsheet. I've tried deleting the row & plugging in the total, but the %s
are still different. I would like to understand the logic behind the pie
chart %. It seems that they are always adding up to 100% even if the total on
the spreadsheet is not.

 

[Bernard Liengme]

Right click on the pie in the chart
Select Format Data Series
Open the Date Labels tab
Uncheck "Percentages"; check "Values"
best wishes