Pie Chart Percentage incorrect
The values will change based on the data. Here's what I am currently working
with:
Account Hold 34 4.25%
Awards 153 19.13%
Certification 49 6.13%
Directions 5 0.63%
Disbursements 46 5.75%
Documents 41 5.13%
Entrance/Exit 7 0.88%
FAFSA/SAR 77 9.63%
Loan Certification 9 1.13%
Payment Plan 5 0.63%
Registration 10 1.25%
Request Another Dept 71 8.88%
Student Accounts/Bursar 81 10.13%
Transcript Request 39 4.88%
Turn Around Time 23 2.88%
Type of Aid 150 18.75%
The 19.13% Awards are getting rounded down to 18% in the Pie chart.
Awards
18%
If I right click on the Award value in the pie chart and Format Data Labels,
it shows the 19% and not 18% as the sample in the Format dialog box.
Thanks for looking into it, Bernard.
"Bernard Liengme" wrote:
It would help if you told us the actual vlaues you are plotting then we can
test it.
best wishes
Bernard
"Bryan in Bakersfield" wrote
in message ...
I have a Pie Chart that I have created that I am having a problem with.
The
chart is rounding numbers incorrectly.
One value (out of 16) is 19.13% of the total, yet the pie chart rounds
this
down to 18%. Another value in the same chart is 18.75% of the total but
it
is rounded up to 19%.
I was questioned about this discrepency and found that if I Format Data
Labels with 1 deicmal place, the values do show correctly (19.1% and
18.8%).
But of course now I'm being questioned as to why I changed the format.
Is there a way to fix my Pie chart so it shows the correctly rounded
numbers
without a decimal place?
Is this 'hidden feature' fixed in Excel 2007?
|