Can i use color from row data to replace the timeline chart ?

25 views
Skip to first unread message

Chukkrit Visitsaktavorn

unread,
Oct 15, 2017, 4:32:53 AM10/15/17
to Google Visualization API
dataTable.addRows([
['1', 'Order 1','#EE7752',new Date(2017, 9, 15, 8, 0, 0), new Date(2017, 9, 15, 9, 30, 0)],
['1', 'Order 2','#EE7752', new Date(2017, 9, 15, 9, 30, 0), new Date(2017, 9, 15, 15, 30, 0)],
['1', 'Order 3','#EE7752', new Date(2017, 9, 15, 16, 0, 0), new Date(2017, 9, 15, 17, 0, 0)],
['1', 'Order 4','#EE7752', new Date(2017, 9, 15, 12, 30, 0), new Date(2017, 9, 15, 14, 0, 0)],
['1', 'Order 5','#EE7752', new Date(2017, 9, 15, 14, 30, 0), new Date(2017, 9, 15, 16, 0, 0)],
['1', 'Order 6','#EE7752', new Date(2017, 9, 15, 16, 30, 0), new Date(2017, 9, 15, 17, 0, 0)],
['2', 'Order 1','#EE7752', new Date(2017, 9, 15, 8, 0, 0), new Date(2017, 9, 15, 9, 30, 0)],
['2', 'Order 2','#EE7752', new Date(2017, 9, 15, 10, 0, 0), new Date(2017, 9, 15, 15, 30, 0)],
['2', 'Order 3','#EE7752', new Date(2017, 9, 15, 16, 0, 0), new Date(2017, 9, 15, 17, 0, 0)],
['2', 'Order 4','#EE7752', new Date(2017, 9, 15, 12, 30, 0), new Date(2017, 9, 15, 14, 0, 0)],
['2', 'Order 5','#EE7752', new Date(2017, 9, 15, 14, 30, 0), new Date(2017, 9, 15, 16, 0, 0)],
['2', 'Order 6','#EE7752', new Date(2017, 9, 15, 16, 30, 0), new Date(2017, 9, 15, 17, 0, 0)],
['3', 'Order 1','#EE7752', new Date(2017, 9, 15, 8, 0, 0), new Date(2017, 9, 15, 9, 30, 0)],
['3', 'Order 2','#EE7752', new Date(2017, 9, 15, 10, 0, 0), new Date(2017, 9, 15, 15, 30, 0)],
['3', 'Order 3','#EE7752', new Date(2017, 9, 15, 16, 0, 0), new Date(2017, 9, 15, 17, 0, 0)],
['3', 'Order 4','#EE7752', new Date(2017, 9, 15, 12, 30, 0), new Date(2017, 9, 15, 14, 0, 0)],
['3', 'Order 5','#EE7752', new Date(2017, 9, 15, 14, 30, 0), new Date(2017, 9, 15, 16, 0, 0)],
['3', 'Order 6','#EE7752', new Date(2017, 9, 15, 16, 30, 0), new Date(2017, 9, 15, 17, 0, 0)]
])


Somethings like this

Chukkrit Visitsaktavorn

unread,
Oct 18, 2017, 1:10:01 PM10/18/17
to Google Visualization API
Ok I found the answer just add column with role 'style'

dataTable.addColumn({ type: 'string', id: 'Station' });
dataTable.addColumn({ type: 'string', id: 'Order no.' });
dataTable.addColumn({ type: 'string', role: 'style' });
dataTable.addColumn({ type: 'date', id: 'Start' });
dataTable.addColumn({ type: 'date', id: 'End' });
Reply all
Reply to author
Forward
0 new messages