Simple concept, say I have two columns. The first contains a time or date, and the next a word or two describing an event.

1970, born
1987, graduated highschool
1991, graduated college

Does there exist a program, or a feature within a program like Excel, that takes this data and spits out a timeline where the dates are spaced proportionally and not just evenly spaced? Something like this:

                                          1991
                                          Graduated college
+----------------------------------+------+
1970                               1987
born                               graduated high school

The best solution I’ve found, at least in Excel, is to treat the dates like a histogram or scatter plot so the dots show up in the right place, then add labels after.

  • razorcandy@discuss.tchncs.de
    3·
    3 days ago

    I would do something similar to what you did: create a scatter plot using the years as your x-axis to make the spacing between them proportional, hide the y-axis, but also add labels to the year and event columns whose data you are using for your chart so that Excel can automatically update the data labels to the chart in case you change or add any events.