I have just came across a similar issue. My data is effectively a time series that does not have any values on Weekends & holidays.
I could, as @asgallant suggested, convert my dates to strings and be happy. However, the users would like to Zoom into my data, which appears to only work on continuous axes. The alternative I am considering is using a sequence (1..N) for each of the Dates and displaying the Date values in place of the order numbers. But I am not sure how to configure that. I am happy to either use the index of row or create another column with just numbers in DataTable and reference to dates from DataView. The Date text must be displayed on both, hAxis and Popup Tooltips over data points. Any suggestions on how to do that? Thanks, - vlad On Monday, June 11, 2012 at 2:22:08 PM UTC-4, asgallant wrote: > > I'm assuming you need the dates in the DataTable to do data manipulation, > but they don't have to be date objects by the time they get to the chart. > Use a DataView to convert the dates to strings and draw the chart based on > the view - this will make the chart draw with a discrete axis instead of a > continuous axis, which will fix the problem for you. > > On Monday, June 11, 2012 1:37:57 PM UTC-4, Teliac wrote: >> >> I have a line chart which plots portfolio value against the date. The >> dates in the data set are only market dates - no weekends or holidays. >> However when the chart is drawn, it draws a long gap between two >> consecutive market days that cover a weekend or holiday (from a Friday to a >> Monday, for example). Is there a way to show the Friday to Monday as a >> single, one day gap rather than the three day gap the chart currently draws? >> >> I have been using Google Vis for a while, and I believe this desired >> behavior was previously supported but I have not been able to find other >> discussions on this. >> >> I do not want to use he annotated timeline for a variety of reasons, and >> it is important for me to keep the horizontal axis as a JavaScript date >> type for client side manipulation purposes. >> >> Thanks, >> >> Teliac >> > -- 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/0934fdf8-df51-467d-a619-d3373aea02b7%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
