Line Chart - timeofday on x axis not working

[Timmy-Habesha]

So, I'm trying to create a LineChart wtih time of day as x axis, not related to any given day but represents a 24hr period. The image attached shows graph created by Excel. 

Any way to create this line chart using google charts? I tried for over a week but failed. The data is at:

 https://docs.google.com/spreadsheets/d/1dxwcC0pGOr5wWiVxezK5xJkg-MvFGliCEd2Zw7GBHe0/gviz/tq?range=A1:J33

Please and thanks.

[Daniel LaLiberte]

Hi Timmy,

I was able to insert chart in a copy of the spreadsheet you posted (https://docs.google.com/spreadsheets/d/1dxwcC0pGOr5wWiVxezK5xJkg-MvFGliCEd2Zw7GBHe0/edit#gid=0)

but I can't share it publicly.   Attached is an image.

All i did was Insert Chart, select the line chart, plot nulls, and fix a couple data values that were way higher than probably intended.

The timeofday values might be shifted due to timezone issues.   Not sure what can be done about that.  The values are actually transmitted to the chart as milliseconds, which means it won't necessarily know what the proper relative time should be.  I'll have to look into that further.

--
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/45e232c7-6c84-4f60-8db0-7cf8f83fd9ec%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Daniel LaLiberte

dlaliberte@Google.com   5CC, Cambridge MA