Colorful House of Math logo
Log in

How to Create a Box Plot in Excel

Here is the instruction for making a box plot in Excel.

Excel Instruction

Making a Box Plot

1.
Enter your data set in one line in Excel.
2.
Highlight your data set and insert a box plot.
3.
Add chart elements and make changes so your box plot appears informative and clear. Remember to title your plot!

Example 1

Make a box plot of the point distribution of scores on a school quiz:

1, 3, 5, 6, 6, 1, 3, 3, 4, 2, 2, 4, 6, 5, 2, 4

1.
Open a spreadsheet in Excel and enter all the data points into a series of cells across one line. It’s up to you if you want to write them in a row or a column.
2.
Highlight all the points and put them in a box plot.

Spreadsheet in Excel showing how to make a boxplot from data

3.
Now your box plot looks like this

Boxplot from data

Add an appropriate title to make the chart even more explanatory. You can also add the axis title “Points” on the vertical axis.

Spreadsheet in Excel presenting boxplot editing

The final box plot should look like this:

Edited boxplot

Want to know more?Sign UpIt's free!
White arrow pointing to the LeftPrevious entry
How to Create a Line Chart in Excel
Next entryWhite arrow pointing to the right
How to Create a Histogram in Excel