How To Create A Box Plot In Excel (Including Outliers)

In this tutorial, I’m going to show you how to easily create a box plot (box and whisker plot) by using Microsoft Excel. I’ll show you how to create a simple box plot with one data set, as well as multiple box plots so you can have two groups side by side.

HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Software (Microsoft Excel 365 ProPlus)

FOLLOW US

AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.

[gabrialpetersen]

Amazing simple explanation. I like how you showed the other functions that deal with quartiles and all of that stuff.

[summiha]

Thank you! You have no idea how helpful this video is. I'm taking Statistics this semester, and I've been avoiding creating box plots, but after watching this video, it is very easy. 💗💗

[dontcallmenice]

Refreshing video, straight forward and answered all my questions simply and precisely.

[TupBuph]

Phenomenal understandable explanation, as well talking about the important numbers attached to this data. You're the GOAT!

[Jfm]

Clear and no fluff tutorial - it's true! Lengendary!!! Awesome vid. Thank you.

[howtomasterexcel]

Well explained. Short and crisp. It saved me a lot of time. Thank you very much!

[mahmoodahmad]

Very straight-forward and simplified explanation. Thanks Steve!

[JuanesChiwirosky]

Exelent video, it went straight to the information I was looking for (what is a box plot) and even explained further (what is a quartile etc)

[xyclos]

Fantastic way to explain and teach. Thanks a lot Steve!!

[jasoncilio]

Helpful. Straight forward. Good examples. Excellent tutorial. Apprecaited.

[seanjones]

Thank you brother. You saved me in the last hours of my Graduate, Statistics Class. I just subbed👍🏾

[NikhilKumar-mnqy]

Excellent presentation. I think this is the simplest video explaining Box Plot. Thank you..!!

[ramzyhedia]

Well done. Very clear and easy to follow. Thanks a lot

[drvdlow]

Amazing teaching skills. Made my life easy. Bless you mate

[xXTheSalvationXx]

Damn thanks for the tip at the end with the labels on the axis...been struggling hard with this. Can't believe they haven't fixed this problem yet since years already...

[abi-wilkin]

Well explained and exactly what I needed, thank you so much!

[faribaaminalroayae]

Thanks for the fantastic video; it really helps my students understand the Box Plot.

[dicksonhaulai]

You just save my life.. Thanks so much...Nice explanation..

[maxiduhuan]

Nice video. It helped me a lot. Thank you sir !

[aocean]

This King is really about to help me pass my Data Analysis final