View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
KristaR KristaR is offline
external usenet poster
 
Posts: 2
Default Pie Chart percentage

Figured out my problem. The second number is my total. The percentages are
correct. Oops!

"KristaR" wrote:

I am working in Excel 2007. I have a simple pie chart.

Two numbers are used:
9,607,932
261,228,187

I am using percentages out to two decimal places in the data labels, but the
labels don't match the percentages that were calculated in the Excel
spreadsheet.

Calculated = 3.68% and 96.32%
Displayed labels = 3.55% and 96.45%

How can I show the correct percentages in my chart labels? Am I missing
something in the label attributes?