I have a Google spreadsheet with two sheets. The first one is for data input from my Android phone using Tasker. Input sheet looks like this:

clock   duration
16,25   29
6,45    23
16,3    35

where "clock" indicates time of departure (from work or home) and "duration" indicates travel time from home to work or vise versa.

Another sheet has these clock values converted to Google spreadsheet time format, and the same corresponding durations:

 16:25  29
 06:45  23
 16:30  35 

Now I want to visualize these in scatter plot. Problem is that the sheet is automatically updated every time I leave from home or work, so the input lines alternates between around 7 and around 16 and when I plot these I get the values in the order they are on the sheet like so:

example scatter plot

But what I want is that the x-axis is constant say from 6 to 18 and the values plotted in this range. This works with normal numbers but time values just appear in the order they are in the sheet.

  • 1
    I suspect your time values are really text that looks like time. One can usually see this by the alignment; text is left-aligned. The timevalue functions can be useful for converting text to actual time.
    – user79865
    Aug 3, 2016 at 11:27

1 Answer 1


Maybe you have "Treat labels as text" checked for the Horizontal axis.

enter image description here

This has 04:00 and 18:00 added to show more labels on the x-axis, and minor grid lines added.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.