On the chart, right click one of the values
Select Format Data Labels for dropdown menu
On Number tab, set the number of decimal places required
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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