[Excel] How to make a range dot plot

Display a range of values and check where categories invert their positions.

Range plot in Excel
Range plot in Excel.

Design notes

  • Sort categories by the average value.



  • 00:10: Use a rank function to position categories along the y-axis
  • 00:15: Columns [Merr] and [Ferr] store the difference of [Male] and [Female] to the [Pop].
  • 02:25: Columns [Y0] is used to place category labels.