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

[@summiha4548]

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. 💗💗

[@drtamblyn]

Thank you. I came here specifically because I couldn't get the labels on the x-axis. I was about to convert my data to a list with categories in the first column, as you show, but thought, no, that's crazy; there must be a better way. You confirmed that there is not! Thanks.

[@marlasiacharles9149]

Same here I was desperate to find out a way, turns out there’s no way😭

[@Jfm2021]

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

[@seanjones7474]

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

[@gabrialpetersen914]

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

[@StevenBradburn]

Thanks Gabrial

[@SantoshSingh-yp4vp]

​@@StevenBradburn please add levels, highlight the points

[@TupBup631h]

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

[@dontcallmenice1879]

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

[@NikhilKumar-mn5qy]

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

[@suzymagnin4677]

So many channels try to explain excel but your videos are the most understandable and easy to follow. Thank you!

[@howtomasterexcel9702]

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

[@jasoncilio3192]

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

[@mahmoodahmad2944]

Very straight-forward and simplified explanation. Thanks Steve!

[@roberthaggkrantz1910]

Great Video and great explanations! If you activate legends on the graph and then right click on the name of the series you can choose to set legends as a horizontal type which will then be placed on top off the graph, and then you can just drag it down below the graph.

[@xyclos]

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

[@aocean6135]

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

[@sree6779]

That was a great video thanks steven, I have a solution for your problem, now if you go to the + sign on the right side of the box plot, there are multiple things you see, and in there, at last, there is a row called a legend, when you click that, you can easily create legend without stacking the cells like this.

[@cpt_4meric4]

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...

[@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)

[@faribaaminalroayae4710]

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

[@cyrielledelvenne7967]

Hi, I cant' see 'statistical chart' on mine... Do you know how I could find it? Many thanks

[@robynxhollie]

Thank you! Saved me from going mad doing my last assignment!

[@StevenBradburn]

You're welcome!

[@drmucahiderdogan]

Excellent tutorial.

[@abi-wilkin]

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

[@TheMrKamik]

Thank you so much, it helped me a lot with my diploma thesis, where I want to interpret my NASA TLX data via Box plots.

[@BinduDubey-j3p]

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

[@deboesengnazo4213]

Best explanation I've come across 👌

[@dicksonhaulai6815]

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

[@cassidysmith4750]

Oh thank god, I was losing my mind trying to get my group labels to appear on the x-axis !!!!

[@StevenBradburn]

@@cassidysmith4750 very welcome

[@SulemanKhan-uy1co]

Explained Beautifully

[@ramzyhedia1277]

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

[@MathsonRams-iw4fg]

Understandable and knowledgeble✊✊

[@Harpoika]

Great explanation. You also confirmed my suspicion that the outliers must be selected separately for all boxes, which is very silly. Do you happen to know a way to edit that option for all the boxes at once?

[@YixuanLi-p3p]

That's really really really helpful. Thank you soooo much:)

[@Azghouls]

Wonderful explanation! Thank you!

[@MToddGriffin]

Fantastic tutorial

[@salwaabdelrahman7606]

it is very simple and interesting thanks a lot Steven

[@jessicasierra5815]

thank you ! but where did you get the new value number of 30 from ?

[@kehaseneway7116]

so very excellent tutorial, special thanks dear

[@StevenBradburn]

Very welcome

[@strong_believer]

Very simple wonderful explanation

[@AdrianaDusso]

Very useful. Can you include how to include dots for the values plotted

[@guthrieblacketer34]

To change the Legend names, select the graph and click "select data" under chart design. In the legend entries select your data series and then click on edit in the toolbar. This will allow you to change the series name in your legend.

[@diabeticdave7840]

I've tried this and unfortunately doesn't change the legend on the X axis :(

[@天下有贼]

!!!! So detailed! THANKS A LOT!

[@vicentesubiabre2302]

Keep up the good job!

[@aayushjangir5085]

Amazingly explained tutorial! thanks!

[@StevenBradburn]

Thanks :)

[@edqedweaqd]

Insane explanation

[@ashneelsharan3463]

great work. well done👍

[@SCM1090]

It has been 2 years now so a lot has changed and maybe it was added in a recent update but if you create a box plot, click on the plot data go to the top left corner, and select the little arrow near quick layout, it gives you the ability to input horizontal and vertical axis.

[@franciscavarpit6554]

Thank you very much. Very helpful

[@mr.jonathanvictini3701]

Amazing work

[@ousmanebolly6651]

Hello sir Thanks for your clearly explanation I have a problem with boxplot When i use twi differents types of data That is To Say, quantitative and qualitative data ( geology data the grade of AU and Rock types)

[@pkvivekanandan3910]

Simply great, well explained easy to follow. Thanks to Steven Bradburn.

[@nathantebbens634]

Very helpful video!

[@masio2605]

Awesome video. Thank you so much, sir!

[@aimanghanimalik889]

i love you for saving me.... 😭😭

[@AmmadDivinatory]

Best explanation

[@mohamedidris7435]

Superb and simple explanations,,would you kindly upload the video how to do a histogram chart

[@StevenBradburn]

Thanks! Does this help: kzbin.info/www/bejne/Z6Sve6utrbdroMU

[@ShaniGoldfarb]

Thank you for the video. Do you know how to change color of a single box plot (formatted like the last option of this video..)? Or perhaps change the distance between boxes in the previous format.

[@riddle672]

This was so helpful…😊

[@dariuswong8279]

I hope you can answer my question soon because I'm on a deadline and I never used excel before but how do I manually represent the mean lower upper quartile median etc for group 1 and 2 of the data set?

[@DewanggaPrabowo]

7:28 After you make the plot with ordinary column name like the first one, and then right click on the graph then select data There is switch button in the middle, click it see if it works

[@ivonnerico1786]

¿Hay manera de agregar los datos de la gráfica en una tabla debajo de la misma de manera automática? o tienes que hacer los cálculos con fórmulas como los hiciste en el video?

[@Hk15489]

Great video ❤ thank you

[@pietervrancaert4977]

Hi, I found an easy way on how to get the labels on the X-axis. Just go to chart design --> add chart element --> legend --> then just simple choose the last option where the legend is switched onto the x-axis instead of the side of the chart in your video.

[@StevenBradburn]

Thanks for the tip Pieter!

[@thedonkarlosgh]

Thanks for this. But I realised it only puts the legend at the bottom but it doesn't really label the x-axis.

[@maxiduhuan5410]

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

[@sarahmurless4249]

Thanks for video. With the final method you demonstrate, how do you change the colours of the boxes?

[@JohnStephenson-p5t]

How do you order the box plot for cost data where lowest cost should be in the first quartile rather than the fourth quarter? Thanks

[@allanquidilig2770]

Thanks for the amazing tutor and explanation..but I have some issue..my data is differences(Target 0) Range: -7 to +7...its not showing the same...Please send me simple intruction how to calculate this..thanks...

[@sheryll9966]

Awesome! Thank you!

[@robertsontirado4478]

Awesome, thank you.

[@71Deba]

Excellent. Thank you so very much

[@StevenBradburn]

Very welcome

[@abujaforshamsuddin9336]

Really Good, Thanks

[@elalaelasariuinjakarta7548]

It is a very good video. many thanks!

[@PiduguVijay]

very useful tutorial. thanks Steven

[@masoroniptick4727]

Where is the 30 value came from, can you explain how you get that value for me ?

[@nicoletahotaran9934]

where can we find the Box Plot if we have microsoft office under 2016?

[@benhermann3038]

To create legend entries in Excel 2019 select the column headers including the data which may be arranged side by side. Limitation: Excel doesn't support more than 7 boxplots side by side in a single graph.

[@ok-kk3ic]

Thanks

[@sharlasmith7728]

Unless you create them manually with stacked columns....

[@BishoujoMegami]

Mine only supports 3 😭

[@BishoujoMegami]

​@sharlasmith7728 how do you do this!? I'm struggling to get 4 in a row!

[@adetolaadebowale890]

easily understandable. Thank you🥳

[@ObinwanneAlisigwe]

Thank you Steven

[@kabandasafi9132]

How have you grouped the group in the 2nd chart all you typed manual in excel sheet

[@combativesoup1684]

lets say i have a data set that is exponential, but i linearize the set. is it better to do this box test on the exponential set or the linear set?

[@halani6929]

I dont have excel 2016, how will I create tht box whisker graph because my excel lacks tht option

[@nidhinbabu9451]

Have a doubt!! When you added a new value to the dataset, which is 30 here, wouldn't the min value change from 45 to 30???

[@swatighosh1865]

Hi, I just wanted to know one thing that why 30 is not considered as minimum value but an outlier?

[@jaimedpcaus1]

Excellent!

[@12dfghas.1]

Hi, for outliers, if I e.g. there is an outlier, but i would like to put the amount 'inside' my diagram rather than presenting as a outlier, what should be done?

[@jpanoz9747]

Thank you so much

[@rubydiprose8968]

thanks man

[@mingyingqin745]

Hi the name of each group of data maybe could be added by editing "Honrizontal (Category) Axis labels" in the "Select Data Source.

[@mingyingqin745]

Oh sorry I tried this, it didn´t work.

[@ramjosyula8965]

nope, you get a weird box plots...

[@diaconescutiberiu7535]

What is the benefit of excluding the median? I don't understand this inclusive/exclusive quartile formula of excel. Why would you want to lose a data point?

[@skyfong]

For small sample size, the inclusive method is recommended as the inclusive IQR is always narrower than exclusive one. Also if the median is one of the data like in the odd numbered dataset, inclusive method should be used (ie not to ignore this data) where the median will be part of the Q1 and Q3 calculation.

[@richardsoos8902]

Thank you

[@mominasarfraz5346]

Lower and upper limit comes in minus?is that ok?

[@googlegoogle1610]

very great :)

[@sanikhan1851]

After drawing the box plot, how to re-distribute the data with variance?

[@erichalsing299]

THANK YOU!!

[@StevenBradburn]

You're welcome!

[@Boli010]

thank you .

[@ThokoGunde]

Super

[@tyrone8112]

ok so how do you make excel not have an outlier and actually plot a boxplot with every point included and the final mean, IQR, Q1 and Q3 that takes the so called outlier into consideration? i would like to make a box/whisker plot that has the whiskers include the outlier points.

[@AnnekeNaseef]

My outlier is so far away it compresses the rest of the boxplot into one line. How do I make the boxplot readable while keeping the outlier in the data?

[@ramjosyula8965]

Go to the axis options ie. click on the Y axis values, select the axis options (click on the histogram) and adjust the min and max values. That should fix it. Hope I make sense.

[@TonioChad]

Thanks

[@rabisroy]

How to add labels...?

[@SantoshSingh-yp4vp]

Right question