Google Annotated Timeline chart shows wrong graph

[raj]

We are using Google Annotated Timeline chart.

There is an issue which I am unable to trace to rectify.

We use this to show price graph for over a period of past 12 years.

We have data from Jan 2003 onwards in a CSV file, with 2 columns, Date and Price.

The data is organized in CSV file as showin below sample data 

Date              Price

01/03/2016    390 (first row in excel, last point on graph)
01/02/2016    335
01/01/2016    330
01/12/2015    325

----

----

----

01/04/2003    315
01/03/2003    315
01/02/2003    305
01/01/2003    290 (last row in excel, first point on graph)

Now, the issue with the graph 

1) Graph should start with Price of Jan 2003, but it show price Jan and month as Feb, 2003

2) The last point of the graph should show Price of Mar 2016, but is shows price of Mar and month as Apr 2016

The CSV has not entry for April 2016.

The behavior means, graph is taking price data correctly, but it is jumping one-month ahead when it comes to month.

Is it the issue with the google chart or the problem is with our data.

Any kind advise is highly appreciated.

Raj

[Daniel LaLiberte]

Hi raj,

I expect you are being affected by the frequently missed 0-based month issue.  See  https://developers.google.com/chart/interactive/docs/datesandtimes

--
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-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@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/90b37a07-832b-4872-a64b-04a8dec2c355%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Daniel LaLiberte

dlaliberte@Google.com   5CC, Cambridge MA