Can I prevent pie chart from rounding?

[davidrock]

Is there a way to force Excel to display a slice for every value in a
chart, even if the value for the slice is very small - say 0.2%? I'm
trying to generate a chart that has 2 slices each with a value of 0.2%
but Excel seems to be rounding them both to zero and only showing a
small slice for one of the values.

Thanks

 

[Andy Pope]

Hi,

I would image that a slice, which is 0.2% of the pie, will never appear
as anything more than a border. And you then is you made the pie chart
very big.

If you have data labels on you can adjust the number format to display
more decimal places.

Is there a way to force Excel to display a slice for every value in a
chart, even if the value for the slice is very small - say 0.2%? I'm
trying to generate a chart that has 2 slices each with a value of 0.2%
but Excel seems to be rounding them both to zero and only showing a
small slice for one of the values.

Thanks

--

Cheers
Andy

http://www.andypope.info