Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Findlink Error | Links and Linking in Excel | |||
Error when entering and exiting excel | Excel Discussion (Misc queries) | |||
#REF error | Excel Worksheet Functions |