Category Archives: Blog

How to make excel display sharp time on graph axis

I was trying to make Microsoft Excel display sharp times on graphs, but took me a while to figure out how to. I had this graph of time to complete the task, per group of participants. The X axis displayed the participant group, and the Y axis corresponded to time. But as you can see on the example, instead of showing rounded times like 2, 5 or 10 minutes, Excel was showing fractions like 01:26, 2:53 etc. I would prefer … Read more →