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.