[Excel] How to make a vertical range dotplot with average
Video tutorial on how to make a dotplot range with mean in Excel
Comparing gaps means displaying the distance between (usually) two categories or between categories and a reference value. Examples:
This is similar to analyzing order and ranking, but our focus is less on the absolute value and more on the gap. Like order and ranking, a key issue with these charts is how to order categories:
It should be clear for the reader when position is reversed (increase vs. decrease, category A is higher or lower than category B). Color and/or arrows are commonly used to signal this.
A bar (vertical or horizontal) is the most common geometry when comparing gaps.
Video tutorial on how to make a dotplot range with mean in Excel
Video tutorial on how to make a range plot in Excel
Video tutorial on how to make a dotplot with a vertical range in Excel
Video tutorial on how to make a slope bar chart in Excel