Google Charts API - Column patterns and "TimeOfDay" data type

google-visualization timeofday
Ben Gotow picture Ben Gotow · Dec 13, 2011 · Viewed 8.8k times · Source

I'm working with the Google Charts API to create a graph of a student's test-taking performance. On the X axis, the graph shows the days of the week. On the Y axis, the graph shows how long the student spent taking the exam. (The goal is for teachers to see if the student speeds up). However, I have a problem:

My data is in the timeofday format, and I'm providing values to the chart as time durations using the Google Charts [HH,MM,SS,MSEC] format. When the chart renders, the Y axis is printed as "HH:MM:SS". I'd really like to customize that because the seconds are pretty useless and it looks messier than I'd like.

The Charts API says you can specify a "pattern" for a column, and I've specified "HH:MM". However, that doesn't seem to take effect at all. Anybody have experience formatting timeofday in Google Charts and know how to do this?

Answer

Distec picture Distec · Feb 8, 2012

The format is buried deep in the API documentation. (http://code.google.com/apis/chart/interactive/docs/reference.html). It is about quarter way down, it says:

If the column type is 'timeofday', the value is an array of four numbers: [hour, minute, second, milliseconds].

Related questions

PHP MySQL Google Chart JSON - Complete Example

I have searched a lot to find a good example for generating a Google Chart using MySQL table data as the data source. I searched for a couple of days and realised that there are few examples available for generating …

Read More
Pie chart with jQuery

I want to create a pie chart in JavaScript. On searching I found the Google Charts API. Since we are using jQuery I found that there is jQuery integration for Google Charts available. But my problem is here the actual …

Read More
Remove padding or margins from Google Charts

Example fiddle How do I remove padding or margins in this example?

Read More