How to Create a Box Plot in Excel

In this Excel tutorial, you will learn how to insert a box plot into your spreadsheet in Excel.

Median calculation

Calculate the median, Q1, Q3, min and max of the data. Calculate box top (Q3-Q2), box middle (Q2-Q1), box low (Q1), positive error (max-Q2) and negative error (Q2-min).

box plot data table

Inserting box plot

Click on INSERT tab, click on Insert Column Chart and then click on Stacked Column.

ribbon box plot

Right click on the chart and click on Select Data. Select "box low, boxmid and box high" range.

box plot select data source

Right click on the bottom blue bar and change both the OUTLINE and FILL to nothing.

outline fill box graph

Click on the + sign, select error bars. Choose series 2. Click on more option. In the task bar to the right select CUSTOM and then SPECIFY VALUE.

box chart custom specify value

add error bars excel box

For positive error values select error up and for negative error values select error down.

custom error bars box

That’s it. Box Plot is ready.

Excel Box Plot

Further reading:
How to insert Box and Whisker in Excel