[Excel] How to make a vertical range dotplot with average

A useful vertical range plot with a central point.

A vertical range plot in Excel
A vertical range plot in Excel.

Design notes

  • Use this to represent gaps and differences to the central value.



  • 00:15: Columns [LimSup] and [LimInf] calculate the difference between [Max] and [Avg], and [Min] and [Avg]; they will be used to define error bars.
  • 02:10: Column [Y0] is used to place x-axis labels.