Forum Discussion
vitoaiaco
Mar 18, 2025Brass Contributor
Pivot chart does not read hundredth of seconds from pivot table
Hi, I am kindly requesting for your help.
In the attached file you will find in the "Data" tab the raw data with swimmers' styles, swimming distance and time. In "time" column the race time is recorded in m:ss.hh with "hh" being hundredth of a second.
You will notice that in the "Dashboard" tab (specifically the chart on the top right titled "No. of races for each style with avg" rounds the time by seconds and does not pick up the decimals.
Since hundredth of seconds are extremely important in this exercise, how can I get the chart to pick up the times correctly?
Thanks in advance
Vito
Instead of the Time column, use the Time Calc column in the pivot table:
Change the number format of the value field to m:ss.000:
Result:
The pivot chart will reflect this.
2 Replies
Sort By
- vitoaiacoBrass Contributor
Solved... Thank you so much for help!
Much appreciated
Instead of the Time column, use the Time Calc column in the pivot table:
Change the number format of the value field to m:ss.000:
Result:
The pivot chart will reflect this.