I have been completely stuck with this. In the chart inspector the 'format' drop down menu has 'number' 'currency' 'percentage' etc. and I can create charts with these, but not 'duration'. Why not? I can understand why 'date & time' is unavailable but not duration???
Basically I am training for a running race and want to see my progress in a line chart as my times get quicker each week.
I have a list of training times (duration mm:ss) in a table: 25:34, 24:55, 26:12 etc. When I select all the times and create a chart no data appears on the chart.
The Y axis (value) should be in time ie 00:00 - 30:00 but is 0.00 - 4.00
Any help greatly appreciated.