Re: Times on hAxis

62 views
Skip to first unread message

asgallant

unread,
Oct 5, 2012, 10:50:22 AM10/5/12
to google-visua...@googlegroups.com
Normally, I would say you could use "datetime" data type for your data and format the hAxis to display time in the format you want, but that only works if you aren't using stacked bars (which are necessary to emulate a gantt chart), as the API does not handle stacking Dates well (you get very weird results if you do).

There is no way to get regular numbers to display in a time format.  The best you could do would likely be to label your start time 0 and go by number of minutes from that point, something like this: http://jsfiddle.net/asgallant/VLPHs/

It's not a particularly satisfying solution (at least, not to me), but if you come up with something else, I would love to hear it.

On Friday, October 5, 2012 7:26:14 AM UTC-4, Pete Smith wrote:
Hi,

I'm trying to do a graph in a gantt style, and I've got something working pretty much.  However, the bar lengths are measured in minutes rather than days.

What I'm trying to display is times taken for given tasks.  For example:

Start time: 11:00
Step 1.  Leave house and walk to the shops - 1 hour
Step 2.  Buy a newspaper - 15 minutes
Step 3.  Walk home - 1 hour
Step 4.  Watch TV - 2 hours

That kind of thing.

I've spent the entire morning here trying to figure out how I can format the X axis to display this range, and also how to input the above into a data table, but I'm getting nowhere!

Can anyone help?

Thank you.
Reply all
Reply to author
Forward
0 new messages