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.