View Single Post
  #1   Report Post  
Tracey
 
Posts: n/a
Default Percentage calculation error

I have an excel pie chart which calculates percent of total. When I set the
format to display one decimal point (ie. 65.8% and 34.2%) the numbers
displayed are accurate. However, when I change the format to display no
decimal points, the chart displays 65% and 34%. The 65.8% is not rounding up
to 66%. How do I correct the rounding on the chart?