Box and whisker plot excel multiple series

A box plot is a type of plot that we can use to visualize the five number summary of a dataset, which includes:

• The minimum
• The first quartile
• The median
• The third quartile
• The maximum 

This tutorial explains how to create and interpret box plots in Excel.

How to Create a Box Plot in Excel

Perform the following steps to create a box plot in Excel.

Step 1: Enter the data.

Enter the data in one column.

Step 2: Create the box plot.

Highlight all of the data values.

On the Insert tab, go to the Charts group and click the Statistic Chart symbol.

Click Box and Whisker.

A box plot will automatically appear:

To see the actual values that are summarized in the box plot, click on the plot. Then click the green plus sign that appears in the top right corner.

How to make a box plot in excel mac

Then check the box next to Data Labels. The following labels will automatically appear:

Here is how to interpret the labels in the box plot:

Min: 3. This is the smallest value in the dataset that is not considered an outlier.

For this particular example, there are no outliers.

Q1: 5.2