Hi,

Thanks to all, I have ran the data from the percentage data and set to run
off value rather than percentage and this is now adding the correct numbers.

Thanks for all of your help.

Paula


"David Biddulph" wrote:

When I altered the format of the data labels from 2 decimal places to zero,
it rounded to the nearest as I expected. Make sure your labels are set to
use "Value", not "Percentage".
--
David Biddulph

"Paula" wrote in message
...
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