View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Percentages in pie chart

It rounds 3 up and 2 down to get 100%. How else would you you do it?

Does this significantly change the "meaning/interpretation" of the chart?

"Paula" wrote:

Hi,
I have a pie chart with five categories but I need to show them in the pie
chart as whole numbers.
My values are 13.68%, 2.56%, 8.55%, 14.53%, 60.68%

I expect the chart wants to add up to 100% in round numbers so I expect it
to round the 14.53% up, and the 60.68% up, however what it actually does is
rounds the 14.53% down to 14% and the 60.68% down, which is incorrect.

Please can you advise how I can resolve or explain this?

Thanks