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 date 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.