Get Box Plots Template

Calculate quartile values from the source data set. Calculate quartile differences. Create a stacked column chart type from the quartile ranges. Convert the stacked column chart to the box plot style.

A boxplot is a standardized way of displaying the distribution of data based on a five number summary ( minimum , first quartile (Q1), median, third quartile (Q3), and maximum ). It can tell you about your outliers and what their values are.

Select cells E3:G3 -- the heading cells -- then press Ctrl and select E10:G12. On the Excel Ribbon, click the Insert tab, and click Column Chart, then click Stacked Column. If necessary, click the Switch Row/Column command on the Ribbon's Design tab, to get the box series stacked.

On the Insert tab, in the Illustrations group, click Chart. In the Insert Chart dialog box, on the All Charts tab, click Box & Whisker.

With Excel 2016 Microsoft added a Box and Whiskers chart capability. To access this capability for Example 1 of Creating Box Plots in Excel, highlight the data range A2:C11 (from Figure 1) and select Insert > Charts|Statistical > Box and Whiskers. The chart shown on the right side of Figure 1 will appear.

On the Insert tab, in the Illustrations group, click Chart. In the Insert Chart dialog box, on the All Charts tab, click Box & Whisker.

A box and whisker plot also called a box plot displays the five-number summary of a set of data. The five-number summary is the minimum, first quartile, median, third quartile, and maximum. In a box plot, we draw a box from the first quartile to the third quartile. A vertical line goes through the box at the median.

Box plots show the five-number summary of a set of data: including the minimum score, first (lower) quartile, median, third (upper) quartile, and maximum score.

To create a box-and-whisker plot, we start by ordering our data (that is, putting the values) in numerical order, if they aren't ordered already. Then we find the median of our data. The median divides the data into two halves. To divide the data into quarters, we then find the medians of these two halves.