Create a Boxplot in Excel

Your goal

You need to create a boxplot of numerical data in Excel.

Step-by-step tutorial

First select your column of data. Here we're using annual precipitation in Central Park :

Annual precipitation in Central Park, 1869-2019
Annual precipitation in Central Park, 1869-2019

Next go to the Insert tab and choose the chart icon in the following figure. You will see choices for histograms and boxplots (also known as box and whisker plots). Choose a boxplot:

Choosing a boxplot
Choosing a boxplot

The resulting boxplot should look something like this:

Boxplot for annual precipitation in Central Park, 1869-2019
Boxplot for annual precipitation in Central Park, 1869-2019