I have a chart that has a time axis and shows when certain events began and ended (specifically, the beginning and end of moderator terms on Stack Overflow):
How to realize such a chart in Google Sheets? It does not have to look exactly like the chart above, just follow the same concept. The closest thing I found is the "stacked bars", but there's still something to figure out in the data generation for it.
Ideally, the input data would be in a simple table like
Name Beginning of term End of term
with the rest calculated from it. (I'm happy to ignore the blue/purple distinction on the example chart.)