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)
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.
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???
