Can I prevent pie chart from rounding?

  • Thread starter Thread starter davidrock
  • Start date Start date
D

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
 
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


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top