Timeline from table in Sheets with five columns

31 views
Skip to first unread message

Ingeborg Altern Vedal

unread,
Mar 2, 2016, 6:44:07 PM3/2/16
to Google Visualization API
I'm trying to create a timeline chart of world leaders based on a table in Google sheets. I would like to give one of the columns the role 'tooltip'. How may I do that

Ingeborg Altern Vedal

unread,
Mar 3, 2016, 12:35:50 AM3/3/16
to Google Visualization API
I was to tired to explain yesterday, I'll try now:
What I want is similar to this:
https://developers.google.com/chart/interactive/docs/gallery/timeline

But instead of presidents, vice-presidents etc I will have different countries, so that each country get it's own bar. I could make a table with the four columns: country, president, start date, end date. But I need to color-code based on what kind of government (dictatorship, democracy etc). So I thought I put the government in the second column and the president's name in a tooltip-column.

I just can't figure out how to tell in the script that I have a tooltip-column in my sheet-table and which one it is.

Ingeborg Altern Vedal

unread,
Mar 3, 2016, 3:49:04 AM3/3/16
to Google Visualization API
I've also been looking for the following solutions, but neither seem possible:
  1. Make a timeline based two resource-columns:
    1. Color based on a government-column
    2. Label based on a president-column
  2. Turn off the link resource-color and define the colors by options-variable
  3. Make a color-column with hexa-values
I appriciate any suggestions that may help me! Maybe Google might add any of these features to a very nice tool that just need a little improvement?

Ingeborg Altern Vedal

unread,
Mar 3, 2016, 4:48:29 AM3/3/16
to Google Visualization API
Reply all
Reply to author
Forward
0 new messages