Hi Everyone,
I've got a graph that had been a 'dial' gauge chart that looked ok but i wanted to try something different. As the graph displays the average time that something takes i thought id try using the 'Numbers' or 'Digital clock' view (i'm not sure what its called but its the last gauge chart and i think it looks like a digital clock).
The problem i have is that its not displaying the value correctly.
It shows 004944 which technically is correct as the value is 49 minutes, 44 seconds however there are no colons in-between the number sections.
What i want it to show is 00:49:44
I know i could just use a text box to display it but i like the idea of the digital clock (as its a time based metric).
Does anyone have any ideas?
Thanks,
Peter