[Excel] How to make a vertical lollipop

A vertical lollipop for time series or ordinal data.

A vertical lollipop in Excel
A vertical lollipop in Excel.

Design notes

  • When a time series is used or you have an ordinal variable the default option should be assigning them to the x axis.
  • This example starts from a line chart because it’s simpler than a scatterplot, but both could be used.