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.

Right click on the pie in the chart
Select Format Data Series
Open the Date Labels tab
Uncheck "Percentages"; check "Values"
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MaryAnne@Maloney" wrote in
message ...
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.