Forum Discussion
Solved
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 recor...
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.
Solved... Thank you so much for help!
Much appreciated