A few years ago I was working for a project evaluating smart home technology, comparing user expectations at the point of installation with experiences 1 year later. … Read more →
All posts by Luis Carlos Rubino de Oliveira
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 →