Author: Oscar Cronquist Article last updated on September 30, 2018

The Box and Whisker chart allows you to plot distributions in statistics, it also displays local minimum, first quartile, median, mean, third quartile and outliers.

Microsoft designed the Box and Whisker chart to follow the Tukey industry standard. A value is considered an outlier if it is equal to or more than 1.5 length of the box from one of the ends of the box.

How to build

  1. Select data.
  2. Go to tab "Insert" on the ribbon.
  3. Press with left mouse button on "Insert Statistic Chart" button.
  4. Press with left mouse button on "Box & Whisker chart" button.