In Microsoft Excel, a box plot uses graphs to display groups of numerical data across five values, called quartiles. Box plot charts can be decorated with whiskers, vertical lines that extend from the chart boxes. The whiskers indicate variability outside the upper and lower quartiles.

Box and whisker plots are commonly used to display information from related data sets that do not have independent sources, such as test scores from different schools or data from before and after changes in a process or procedure.

In recent versions of Excel, you can create a box and whisker chart using the Insert Chart tool. Although older versions of Excel do not have a box and whisker plot maker, you can create one by converting a stacked column chart to a box plot and then adding whiskers.

For Excel 2019, Excel 2016, or Excel for Microsoft 365, create a box and whisker chart using the Insert Chart tool.