Excel and the cat’s whiskers

Excel Box and Whisker Diagrams

Excel box and whisker diagrams (box plots)
Box and Whisker Charts (Box Plots) are commonly used in the display of statistical analyses. Microsoft Excel does not have a built in Box and Whisker chart type, but you can create your own custom Box and Whisker charts, using stacked bar or column charts and error bars. This tutorial shows how to make box plots, in vertical or horizontal orientations, in all modern versions of Excel.

Author: Terry Madeley

I work with student data and enjoy reading about art and design, data, education and technology.