ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Percentage calculation error (https://www.excelbanter.com/excel-discussion-misc-queries/11169-percentage-calculation-error.html)

Tracey

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?


All times are GMT +1. The time now is 10:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com