-2

My data is in variable increments, anywhere from six to eight hours apart like so:

1-1-2011 00:00:00     100  
1-2-2011 00:00:00     103  
1-3-2011 00:00:00     107  
1-4-2011 00:00:00     109  
1-4-2011 06:00:00     111  
1-4-2011 10:00:00     120  
1-4-2011 14:00:00     132  
1-4-2011 20:00:00     176  
1-5-2011 00:00:00     190  
1-5-2011 09:30:00     221  
1-5-2011 15:00:00     250  
1-5-2011 19:15:00     272  
etc...

When I build a trend line graph, every one of those entries on the 4th and 5th are stacked up in a horizontal line, then it jumps over to the 5th where they stack up again. End result is a stair step instead of a nice growth curve.

I built a test spreadsheet with the above test data. It of course works like a charm. Even after adding a second series.

Anyone have an idea what I might have broken that prevents me from getting sub date granularity on Google Sheet's trend line graphs?

  • Can you please include a screenshot of the graph that you have for the example above? – Lipis Jan 23 '11 at 22:02
  • So it basically skips the hours in the X-axis? – Lipis Jan 23 '11 at 22:13
  • Yes, exactly. No matter what the zoom level is. – cabbey Jan 23 '11 at 22:16
  • @Lipis, just built a test sheet... works fine there. :( reworded question as a result. – cabbey Jan 23 '11 at 22:25
  • 1
    Your screen shot is no longer available. – ale Aug 20 '15 at 18:17
1

Maybe you're using the wrong chart type for display this kind of information. When I selected time line from the Charts for the above data, I'm getting an interactive chart, exactly like the one they are using in Google Finance.

alt text

  • that's the one I'm using too. – cabbey Jan 24 '11 at 7:17
1

Ok, it appears to be caused by entering just enough data to tip the balance somehow. Throw this data into a sheet and apply a timeline chart. You'll get a nice curved line.

1/11/2011 00:00:00 1173
1/12/2011 00:00:00 1270
1/13/2011 00:00:00 1387
1/14/2011 00:00:00 1434
1/15/2011 00:00:00 1458
1/17/2011 00:00:00 1531
1/18/2011 00:00:00 1567
1/19/2011 00:00:00 1598
1/20/2011 00:00:00 1624
1/21/2011 12:14:00 1643
1/21/2011 12:30:00 1722
1/21/2011 13:30:00 1863
1/21/2011 14:00:00 1895
1/21/2011 16:45:00 1990
1/21/2011 19:23:00 2026
1/21/2011 23:59:59 2060
1/22/2011 11:00:00 2134
1/22/2011 19:46:00 2184
1/23/2011 14:00:00 2232

Now add this additional row:

1/10/2011 00:00:00 893

Boom, stair steps.

sample (this is a screen shot of the test chart I linked to in the question.)

What's sad is that it appears to be an intentional data simplification. If the data in the cart bounces up and down within a day, then they don't seem to compress it. it's only if there is only growth or decline, then they compress it to day scoped as soon as you get enough data. It does not appear to be related to the total span of the data, as I did experiments with having the 1/10 data in place, and removing the 1/15 data returns you to a smooth curve.

Short of getting someone from Google to comment on this, I don't think we're going to get a better answer. :(

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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