View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Bryan in Bakersfield Bryan in Bakersfield is offline
external usenet poster
 
Posts: 4
Default Pie Chart Percentage incorrect

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?