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.
- Open a spreadsheet in
Exceland 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.
- 3.
- Now your box plot looks like this
Add an appropriate title to make the chart even more explanatory. You can also add the axis title “Points” on the vertical axis.
The final box plot should look like this:
