[Excel] How to make a range dot plot
Display a range of values and check where categories invert their positions.

Design notes
- Sort categories by the average value.
Video
Notes
- 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.