[Excel] How to make a simple dotplot

A simple and light dotplot that can advantageously replace a bar chart.

Simple dot plot in Excel
Simple dot plot in Excel.

Design notes

  • The quantitative scales in dotplot doesn’t have to start at zero, but make sure there is something to gain from doing so.