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. On Thu, Nov 3, 2016 at 6:02 PM, Timmy-Habesha <[email protected]> wrote: > 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. > > -- > 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 [email protected]. > 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 > <https://groups.google.com/d/msgid/google-visualization-api/45e232c7-6c84-4f60-8db0-7cf8f83fd9ec%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> 5CC, Cambridge MA -- 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 [email protected]. To post to this group, send email to [email protected]. 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/CAOtcSJPajfxp5b0%2BGACL9nHK_%3DMmXme5ErjHo0rR2W_0YNgmQw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
