Hi Pete, LineCharts should work fine with dates in any column. I'm not sure whether by "col 1" you mean the first column (indexing starting at 1), or the second column (indexing starting at 0), so here are both examples: LineChart with date for the first column: http://jsfiddle.net/53w3nph7/ LineChart with date for the second column: http://jsfiddle.net/m0w4fn3v/
If you're still having issues, please modify one of these jsfiddles (or create your own) to exemplify the issue you're experiencing. On Thu, Mar 3, 2016 at 12:26 PM Pete Carlile <[email protected]> wrote: > Thanks Sergey. > > I change the first column to a string (the dates being just the axis in > the graph and it worked fine). > > It appears you can not have a date field in col 1 when calling the > LineChart function (I tried the correct syntax). > > Pete > > > On Tuesday, 1 March 2016 16:08:47 UTC+1, Sergey wrote: > >> Hi Pete, >> >> Your JSON is not syntactically valid. Having "2016-03-02" as a raw value >> is not proper. Please refer to our Dates and Times documentation page >> <https://developers.google.com/chart/interactive/docs/datesandtimes> for >> guidance on how to use dates properly. >> >> On Tue, Mar 1, 2016 at 8:15 AM Pete Carlile <[email protected]> wrote: >> > Hi, trying to use a json create table and run though Google charts line >>> chart. Getting error message. Any ideas. >>> >>> File being sent : >>> >>> { "cols" : [{"id" : >>> "","label":"Date","pattern":"","type":"date"},{"id":"","label":"GBP","pattern":"","type":"number"},{"id":"","label":"USD","pattern":"","type":"number"},{"id":"","label":"CHF","pattern":"","type":"number"}], >>> "rows" : [{"c" : [{"v":2016-02-29, "f":null},{"v":35657.00, >>> "f":null},{"v":1000.00, "f":null},{"v":6626.45, "f":null}]},{"c" : >>> [{"v":2016-03-01, "f":null},{"v":35657, "f":null},{"v":1000, >>> "f":null},{"v":6626.45, "f":null}]},{"c" : [{"v":2016-03-02, >>> "f":null},{"v":35657, "f":null},{"v":1000, "f":null},{"v":6626.45, >>> "f":null}]},{"c" : [{"v":2016-03-03, "f":null},{"v":35657, >>> "f":null},{"v":1000, "f":null},{"v":6626.45, "f":null}]},{"c" : >>> [{"v":2016-03-04, "f":null},{"v":35657, "f":null},{"v":1000, >>> "f":null},{"v":6626.45, "f":null}]},{"c" : [{"v":2016-03-05, >>> "f":null},{"v":35657, "f":null},{"v":1000, "f":null},{"v":6626.45, >>> "f":null}]}]} >>> >>> -- >>> 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/0a14c8ef-f10e-4202-90ad-1b3ec5c6f44f%40googlegroups.com >>> <https://groups.google.com/d/msgid/google-visualization-api/0a14c8ef-f10e-4202-90ad-1b3ec5c6f44f%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- >> >> *[image: unnamed.gif]• Sergey Grabkovsky• Software Engineer• Google, Inc• >> [email protected]* >> >> -- > 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/252fe07c-463e-4324-ba81-9b17bc7dc8d9%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/252fe07c-463e-4324-ba81-9b17bc7dc8d9%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- *[image: unnamed.gif]• Sergey Grabkovsky• Software Engineer• Google, Inc• [email protected] <[email protected]>* -- 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/CAEwwup56HzB8VMNU8FsOQwyAQ%3DaMQ-eVhhemOcKjrPw6_jnBSw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
