View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Pie Chart Percentage incorrect

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?