You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Pie chart issue: numbers displaying with way too many decimals, no way to change this???

Not sure what's going with Numbers. In my duration column, minutes and seconds are displaying normally. But yet when shown in the chart, some of the duration data is showing up with way too many digits after the period. For example why does 15 min 2 sec in the table show up as 15m 2.39999999999998 in the pie chart???


MacBook Pro (2021)

Posted on Oct 24, 2023 6:43 AM

Reply
Question marked as Top-ranking reply

Posted on Oct 24, 2023 12:29 PM

In your duration column the values are shown rounded to the nearest second, probably with a format like that.

However the chart uses the full values with fractional seconds, even if the format is set identically. (bug???)


Round the values directly in the table with this formula (replace B2 by your current formula)

=DURATION(,,,,ROUND(DUR2SECONDS(B2),0))


After that you can set your chart segments to be formatted like their source.



1 reply
Question marked as Top-ranking reply

Oct 24, 2023 12:29 PM in response to ninose

In your duration column the values are shown rounded to the nearest second, probably with a format like that.

However the chart uses the full values with fractional seconds, even if the format is set identically. (bug???)


Round the values directly in the table with this formula (replace B2 by your current formula)

=DURATION(,,,,ROUND(DUR2SECONDS(B2),0))


After that you can set your chart segments to be formatted like their source.



Pie chart issue: numbers displaying with way too many decimals, no way to change this???

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.