Long date time string on x axis

[ve6ji]

I am trying to create a chart using a long date + time string on the X-axis eg. 2016-11-05 15:26:00.  I have created the graph using the Unix Epoch time stamp as  the X-axis series here: http://beacon.va7eca.ca/graph.php but it is not very user friendly.

Any hints on changing the YYYY-MM-DD HH:mm:ss format into something google charts can work with?  

The data is in 1 minute intervals and I need to display 3600 - 345,600 data points.  

The X-axis can be coarse eg 2016-11-05 00:00:00 2016-11-05 01:00:00 2016-11-05 02:00:00 ... 2016-11-05 09:00:00.

Thank you for any tips.

Cheers,

Matt

[Daniel LaLiberte]

Hi Matt,

Your horizontal axis values are of type string, and they are all empty strings.  If you want them to be of type 'datetime' use that, and then specify your values in the string notation.  See the relevant documentation here:  https://developers.google.com/chart/interactive/docs/datesandtimes#dates-and-times-using-the-date-string-representation

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/155fc4f4-ca9e-4b11-8c3b-25f85236dff6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Daniel LaLiberte

dlaliberte@Google.com   5CC, Cambridge MA