Excel Magic Trick #124: Box Plot or Box & Whisker

[whitneyxox4u]

thank you! you helped me sooo much!



[StreetKingEvolution]

Thank you so much!

[REDivivus5]

easy to follow and incredibly helpful even with excel 2010. (: thank you!

[Reecie5699]

You need a pop filter or something

[BenPajamas]

So much help!!!!

[GE0SH]

not working, I keep getting this message "...arrange the data on your sheet in this order: opening price, high price, low price, closing price..." but I have that data set up just as you do

[danielkueh]

Do you know how to create multiple box plots?

[JaqualinIsBallin]

Thank-you thank-you thank-you!!! Helped so much with my AP Statistics final project, you have NO idea how stressed out I was! Thanks :D

[ExcelIsFun]

@JaqualinIsBallin , you are welcome!

[WHATYAAAAAAAAAAAAAAA]

How do you put multiple box plots on one chart though?

[mohabat22]

Thank you! It took me 30 minutes to do it with your video, kept pausing and such, but it was great!

[IKenSpelGud]

Saved my ass for a math project, many thanks mate

[jscheong93]

it helps! thank you!

[kooger94]

very helpful! thanks a lot :)

[tondominguez]

Thanks a lot, followed on Excel 2010 and it still worked :D

[ExcelIsFun]

@tondominguez , EXCELlent! I am glad that it worked!

[musiqab]

Thank You!!!!!

[ExcelIsFun]

@musiqab , you are welcome!

[ExcelIsFun]

@musiqab , u r well come!

[younglife88]

Very Useful! Thanks so much for the help!

[ExcelIsFun]

@younglife88 , I am glad that it helped!

[ExcelIsFun]

@younglife88 , I am glad that it helped!

[christiiiiinaa]

The amount of love I have for you... I can't even express it.

[ExcelIsFun]

@christiiiiinaa , Cool! I am glad that it helped!

[faridzal]

Thanks bro.... It is really useful for my biostats.... Very helpful....

[ExcelIsFun]

@faridzal , I am glad that it helped!

[sk8anddie816]

Absolutely fantastic! you helped me through my engineering homework better than cramster ever will

[dab1477]

thank you. very informative.

[GibbsGibberstein]

my teahcer told me to tell you that 25 High School students i AUstralia watched this vieo. You helped us and i would like to thank you

[ExcelIsFun]

You are welcome! And if you are in High School and doing this kind of stuff, that makes you all very smart! And the teacher must be quite good to be teaching you this sort of stuff!!

[theseaqueenerofemma]

I figured out how to change my scale, just in case anyone else wants to know all you have to do is right click on the X axis and select the format axis tool. There will be a heading Axis Options and just highlight the minimum circle to fix and change to whatever number you want to start with. This is probably super obvious to everyone else lol, anyway thank so much for a really good video !!!

[ExcelIsFun]

You are welcome for the video! I am glad you figured out how to change the min and max on the horizontal axis!

[theseaqueenerofemma]

Thank you for this video it's so helpful! I have used your method to create two boxplots and they look great! However for my thrid I need the scale to start at 30 instead of 0 is this possible? Thanks again for a truly informative video!

[theseaqueenerofemma]

Thank you so much! I have used your method to create two box plot graphs which look great. For my thrid boxplot, I want the scale to begin at 30 instead of 0 is this possible? Anyway Thanks again for a very helpful video!

[deadduck12]

Really appreciate it man! I'm in a grade 12 Data Management class and this really helped with showing data on my Summative! Thanks A Lot!

[ExcelIsFun]

You are welcome!

[AkuzaGhost]

amazing, genius, seriously omg.

[ExcelIsFun]

I am glad that you like it!

[nprice0210]

You are a life saver. You made this seems so simple. Without this helpful video, I would not have been able to create a box plot for my homework assignment in Economic and Business Statistics. I just cant thank you enough thank you thank you thank you. I had pause the video and do it step by step as you were doing it to complete all 3 box plots I had to create at one time, but I did it. I had three sheets open at one time creating. Thanks again for your help

[ExcelIsFun]

You are welcome! After teaching Stats for a long time and listening to students complaints, I posted these videos so just so that students had some visual help when they study (and to show how to create stats in the most relevant real world tool; Excel)!!

[DarkstarNovembr]

you sir, are an excel genius

[ExcelIsFun]

No genius, just a guy having fun with Excel!!

[starryeyed110796]

This is cool !

[hynseon]

I AM CONFUSED!

[seamlt]

can you do TWO box plots in ONE chart?

[ExcelIsFun]

Yes. One way o do it is created second data poinst, then with the already created chart selected, go to ChartTools Design Ribbon and in the Data group click the Select Data button and add, edit or delete serties values (numbers) and or categorical data (labels).

[seamlt]

@ExcelIsFun is that how you do it on 2007? can you please be more detailed? please and thank you

[ExcelIsFun]

That is how to do it in 2007.

[Fleabite75]

The instructions for doing a box & whisker plot are easier than any other I've seen. I would point out that a vertical box & whisker plot can be made in just the same way as a horizontal plot by using a stacked column chart and following the same formatting steps as for the stacked bar chart. This give you the median in the plot which the open/high/low/close stock plot doesn't--and you don't have to put a bogus date in the plot data.

[ExcelIsFun]

Thanks for the Hot Tip!!!

[Pink4Kim]

When I do my box plot there is always a line on the bottom. I think it's a continuation of the line on the right side. How can change that?

[ExcelIsFun]

Sorry. I do not.

[206Nish]

@Pink4Kim

I think you're talking about a shadow. Select the box, then go to format, then effects,then shadow, then choose "No Shadow".

[tantrts]

Thanks a lot, bro! I can do my assignment easily now

[ExcelIsFun]

You are welcome!

[dbzfinatic]

nvm excellsfun

[dbzfinatic]

ExcelIsFun, The labels aint copying when i copy and paste to word 2007, help! the ones in blue

[ExcelIsFun]

Sorry I do not know how to help with that.

[dbzfinatic]

The labels aint copying when i copy and paste to word 2007, help! the ones in blue

[Galter08]

Yessssssss. Thank you! Your a hero!

[ExcelIsFun]

I am glad that it helped.

[PeterEhik]

thanks bro, you really helped me out of a tight corner man. Thanks for uploading

[ExcelIsFun]

I am glad that it helped!

[TheSamvir]

Great tutorial by the way helped me a lot. May I ask why your screen is so small?

[ExcelIsFun]

I am glad that it helps. Sceen so small so I can fit into capture screen.

[TheSamvir]

@ExcelIsFun Why don't you try another software? It would make your tutorials even better than they already are!

[TonyMC007]

I thank u my good sir, I would like to ask something.. how do distinguish between symmetric or right/left skewed from the box plot?

[ExcelIsFun]

These are the only other tricks I know for box plot: to show the relative positions of mean, median:

Excel & Statistics 49: Outliers & Box Plot with Median and Mean

[TonyMC007]

@ExcelIsFun Thanks Alot...ure videos are the best tutorials. 

[ExcelIsFun]

I am glad that you like them!!

[toryjaayx3]

YOUR A GENIUS THANX

[ExcelIsFun]

i am glad that it helps!

[mousenz1]

Thank you heaps, this is such a huge help!

[ExcelIsFun]

You are welcome!

[iLoveTheCheese11]

Thank you for this you are a saviour!! helped me in my coursework!!

[ExcelIsFun]

You are welcome!

[JaWinzie]

i need help :(

[ExcelIsFun]

What do you need help with?

[dreller120]

Thanks very much! This was a great tutorial.

[ExcelIsFun]

I am glad that you like it!

[livliv3]

Thanks a lot. This was really helpful! :)

[ExcelIsFun]

You are welcome!

[equax]

For some reason, once I switch from row to column, the values for my X axis go out of range. Is there a way around this?

[ExcelIsFun]

I do not understand your question.

[popodbz1]

You are a DON!! (In english slang - A BOSS!! or A COOL GUY!!) Helped so much thank you

[ExcelIsFun]

You are welcome!

[jwoods17]

Great vid. You have helped out sooooo many college students

[ExcelIsFun]

I am glad that it helps sooo many!

[tdrider2008]

THANK YOU

[ExcelIsFun]

I am glad that it helped!

[equax]

Could I use this method to compare two boxplots side by side? Or can this method only be used for one boxplot?

Thanks!

[ExcelIsFun]

I have not tried it - but I think that you can do it with the "Open-High-Low-Close Stock Chart". Just have more than one data series.

[emmel07]

Thank you professor Girvin! I had the neatest box plot in my class thanks to your lesson.

[ExcelIsFun]

You are welcome!

[Audey]

Great lesson! Very easy to follow and you explained things so well. I'm definitely subscribing, your videos are going to come in very handy for my statistics class this semester.

Thank you so much for making these

[ExcelIsFun]

You are welcome!

[cutee1986]

Thaaaaaaaaanks, you saved my Life :P

[ExcelIsFun]

you are welcome!

[neyann]

thank you very, very much! it helped me a lot in my final math project.

[ExcelIsFun]

You are welcome!

[exemsexis]

Very Helpful, used this trick for my Statistics project. Thank you !

[ExcelIsFun]

EXCELlent!!!! I am glad that it helped!

[negrocornejocostas]

Exelent, its help me a lot!!! i´m gonna pass the exam. Thank you!

[ExcelIsFun]

Woo Hoo! I am glad that it helped!

[bertalmighty]

Seriously, I love you for this!

[ExcelIsFun]

I am glad that you liked the video!

[rorkimaru]

If I could brofist you through the internets right now you know I would.

This was the last graph I needed for tomorrow's report and your vid saved me! Thank you!

[ExcelIsFun]

I am glad that it helped!!!

[rorkimaru]

@ExcelIsFun Oh it really did! My Lecturer has a major love of aesthetically pleasing graphs. No exports from a stats package will do. I will present him tomorrow with a beautiful set of charts with a lovely two tone blue motif. It adds nothing to the quality of the work but I'd put money on it earning me another 10-15%!

[ExcelIsFun]

EXCELlent!!!!

I hope the video helped to get to your goal!



[klevez48]

Best help on this topic so far - I'll utilize this for many excel projects coming up - thanks!

[ExcelIsFun]

You are welcome- I am glad it helped!

[kristyna1986]

Thank you very much!:)

[ExcelIsFun]

You are welcome!

[Toms898]

you are a genius!!!!

[ExcelIsFun]

Not really, just a guy having fun with Excel!

[Kwintenc]

You the man!

[ExcelIsFun]

I am glad that you liked it!

[hensonk2]

THANK YOU!

[ExcelIsFun]

You are welcome!

[emptyxnes]

this is the best explanation anywhere...thanks...this also works for 2010...slight differences..but one can figure it out based on your instructions....

BTW, is it possible to compare 2 box plots next to ea. other? not sure if that question makes any sense.

[ExcelIsFun]

I have not tried it, but you should be able to highlight two sets of data and then select chart type.

[emptyxnes]

this is the best explanation anywhere...thanks...this also works for 2010...slight differences..but one can figure it out based on your instructions....

[ExcelIsFun]

I am glad that you like it.

[samsyed23]

ur the best

[ExcelIsFun]

i am glad that you like it!

[roddickredsox8]

THANKS SOOOO MUCH! You saved my ass on my stat project!

[ExcelIsFun]

You are welcome!

[roddickredsox8]

THANKS SOOOO MUCH

you saved my ass on my stat project

[ExcelIsFun]

You are welcome sooo much!!

[stevenrjj]

STACKEDDDD BARR!!!!!!

[quantum64]

Just want to say thank you. Great video!

[ExcelIsFun]

You are welcome!

[Iannone1993]

loved love loved loved loved this video!

[ExcelIsFun]

I am glad it was helpful!!

[JaggedEdgeFJ]

LEGENDARY <3

[ExcelIsFun]

Thanks!

[ExcelIsFun]

In the video we added Minus 100% error bar to the 2nd invisible bar and Plus Custom to the 4th invisible bar. Why don’t you also add a Minus 100% error bar to the 1st invisible bar and see if that works.

[MuffledTeapot]

@ExcelIsFun Thankyou, this worked very well for my minus figure. :)

[ExcelIsFun]

You are welcome!

[kerowillyam]

thanks heaps :)

no offence but i like how you didnt cut any bits of the video out and when you stuttered it made it kinda entertaining xD

-will

[ExcelIsFun]

I am glad that it helped!

[kerowillyam]

@ExcelIsFun :)

[ExcelIsFun]

Thanks!

[pinkoutloud]

amazing! thank you for this!

[ExcelIsFun]

You are welcome!

[AnGeLiCAnGe]

you just saved me from failing my class!

[ExcelIsFun]

Woo Hoo!! I am glad that the video helped!

[drunkmunks]

Thanks a bunch! I've never used Excel before my college math class. It's a lot of steps but it gets us what we need, right?

[ExcelIsFun]

You are welcome!

[Sowar]

Would I be right to think this wouldn't work if the box plot needs to cross the axis? (i.e. the min or Q1 are negative)

[ExcelIsFun]

Yes, it should work.

[Sowar]

@ExcelIsFun I tried it. I might be wrong but I'm pretty sure it doesn't work if the plot crosses the axis. (e.g. if Q1 is negative).

I ended up finding a solution at peltiertech(dot)com. There's a page there discussing box and whisker plots and what to do about negative values but it was complicated. Love your work though!

[ExcelIsFun]

Cool. peltiertech(dot)com is good!!

[benlax85]

You are an excellent teacher. This helps very much, as have all of your videos. Thank you!

[ExcelIsFun]

You are welcome!

[kelhyder]

i am 12 this is not hard

[CADeane]

You are AMAZING! Thanks for all of your help!

[ExcelIsFun]

You are welcome!

[vrysxyboy2008]

Same here. Thanks for the video!

[ExcelIsFun]

You are welcome!

[vrysxyboy2008]

Same here. Thanks for the video!

[ExcelIsFun]

You are welcome!

[thoosah]

This is really cool! I like when work is done this way - the perfect way! Thank's a lot, helped me a lot with my project to school ;)

[ExcelIsFun]

You are welcome!

[vrysxyboy2008]

@thoosah

Same here. Thanks for the video!

[ExcelIsFun]

You are welcome!

[vrysxyboy2008]

@thoosah Same here. Thanks for the video!

[ExcelIsFun]

You are welcome!