Google Charts Timeline driven by Google Sheet Example?

[Alan Hill]

Hi all,

Can anybody show me a working example of a timeline driven by a Google Sheet? 

Like https://developers.google.com/chart/interactive/docs/gallery/timeline only using a Google Sheet source

Sorry, it's just that I'm having a hard time reverse engineering a PoC from the docs available. Many thanks to anyone who can assist!

Thanks,

Alan

[Ray Thomas]

Here's an example based on the Presidents example in the docs - https://jsfiddle.net/brisray/j8nfu9a2/

Here's the spreadsheet it's coming from - https://docs.google.com/spreadsheets/d/1XqI6BGA5uBioeZza1KxxsXeTT4VHJbLhGBz06h9Rv_U/edit#gid=0

All you need do is create a query, send it, handle any error messages (which is all done by the visualization), populate the datatable, create the visualization and draw it.

The format of the date columns must be set as a automatic, number or date else the timeline will not draw.

Ray

 

[Alan Hill]

That's absolutely brilliant - thank you so much, this is super useful!

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/VVuHb0_6UZo/unsubscribe.
To unsubscribe from this group and all its topics, 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/9338c33e-f37f-4a1d-b486-e3e71f4c20f1%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Alice Köstinger]

Hi Ray,

I was looking for the same problem as Alan today. In my case additional information is needed, e.g. a tooltip for each entry. In my hard coded version I created an additional column with dataTable.addColumn(), but I don't know how to add it via the google spreadsheet, since only 3 columns are possible.

Can you help me in this case?

Many thanks,

Alice

[Benjamin Hill]

Hosted version https://github.com/google/ezgantt