[Excel] How to make a range dot plot

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

Range plot in Excel.

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.