Pie Chart percentage

K

KristaR

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?
 
K

KristaR

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pie chart-remove series w/out changing percent in pie 1
Basic Categorical Pie Chart Question 2
Doughnut Chart linked with the slicer in the pivot table 0
Pie Chart - Percentage of a total? 1
Create a chart from a table in word thats dynamic 0
Pie charts - 0 values 2
Auto positioning of labels outside pie slices 2
Pie of Pie Second Pie Total 100% 2

Top