Construct A Box Plot on Microsoft Excel 2007

NOTE: THIS METHOD ONLY WORKS WITH DATA THAT IS ALL POSITIVE. For data that is all negative or is mixed, there is a slightly different way. If you need to know how to do that, message me or comment and I will make a video.
This is a video I made to help teach people how to construct a box plot (box and whisker) in Microsoft Excel 2007. I hope to add step-by-step instructions to the description of the video soon.
A similar and more complex video on how to do this can be found here: • Excel Magic Trick #124...
I hope that you find this useful. If you have any questions, send me a message or post a comment and I will get right back to you. I can show you how do do this in OpenOffice Calc as well. If you find this video helpful, please 'like' it. Thanks and good luck! :)

[@amnah1993]

THANK YOU SO MUCH!
Your instructions are so clear that i figured out how to do it on Microsoft office for mac! Thanks!

[@vespaamsterdam]

Its help me very well to do easy boxplot exercise! Greets from Amsterdam, The Netherlands.

[@lovefulize]

Thank you so much! was able to use this with excel 2013. you are a life saver and thank you!

[@cindysloowhoo]

Very Useful - I had no idea how to do this for my statistics class.

[@randyshiam69]

Oh my gosh.. This is exactly what i was looking for.. you are genius bro.. Thanks a tonnn!!!!

[@redemptionofthenerd]

Thank you do much! Very helpful - recently fractured my collarbone so can't draw these by hand! Your tutorial is a lifesaver!

[@rangersgirl75]

Thank you sooo much for this video. I needed to make a Box Plot for a project in my statistics class and I was completely lost before watching this. :)

[@atomsemmen244]

Seriously amazing. I am so excited to turn in my math project with a box and whisker plot made from excel. My professor said he would accept a drawing, but this is so much better! Thank you!

[@Brian94Keller]

Thank you so much. This has helped me heaps. Makes box plots so much easier. I am currently a year 11 maths studies student and this is really going to help me in my final school years. Thank you.

[@annanekow347]

Thanks John, really appreciate your help. Now i can sleep.Thanks once again

[@JPaulDiLucci]

This was the best explantion I've seen. Are there any newer versions of excel that can perform this simple task automatically? If it can do least squares regression, it should be able to handle box and whiskers ffs. Any, thanks for the tutorial.

[@soap93160]

Many thanks, this helped me out for my homework assignment :)

[@boryskowal0000]

Finally a simple and perfectly explained tutorial! Thanks!

[@tingersj]

i thought that was really great. very clear and easy to follow :)
you are life saver :)

[@snowchiable]

THIS VIDEO IS AMAZING, YOU SAVED ME SO MANY HOURS OF FRUSTRATION!

[@anacarolinaamitrano7913]

you saved my life! i was able to do it perfectly, excelent tutorial! i needed to do an box plot for an exam and i only have excel 2007! thanks so much! 🇧🇷 even brazilian i could understand it !

[@hannamontana132]

FANTASTIC! Thank you so much!
I have been trying to do this for ages. Thanks a lot Fantastic video with great clear instruction ;)

[@galgotias]

Thank you very much,it is very useful and I appreciate your effort.

[@shoubhiksb123]

thanks man u made my assignment easy

[@AdaClifford]

thank you so much you literally saved my life

[@supportsquad4926]

these was VERY HELPFUL FOR MY AP STATISTICS PROJECT

[@The0fishy0]

thx, finally did finish my math projects

[@tlasz24]

Amazing job, man. Works like a charm.

[@cr8ate60]

Very nice explanation, understood everything.. thanks a lot

[@thejuni1988]

thanks man. Works like a charm in Microsoft Excel 2010

[@kingmagic88]

Thank you, day before my assignment is due, this saved my life your a legend! thumbs up if you agree!

[@mjs87cm]

This is great, thanks. I look forward to the positive/negative version.

[@raf3265]

thanx man because of you i will have 10 for my math :)

[@yk6x]

wow thank you so much, you just saved me...an hour away from handing in my assignment

[@SparkplugSkis]

Great explanation. I struggled trying to mess with this on my own!

[@theniklovely510]

Thank you soooooooo much this really helped me with my Statistics in Management assignment... You are the best!!!!!!!!!

[@mmeellpanda]

Wow ... very good this video! Helped me! Thank you!

[@XxJackFrostxX]

Wow, this was really helpful. Contrary to what you said about it being bad since it was your first video, this was excellent! Keep up the great work!

[@BryenMiller]

Thanks for the video. By far the easiest one to understand! Great job!

[@95duckie]

You sir, are a magician. Thank you so much!

[@laurahoyos1]

Thanks for all the help by the way!

[@kathyrodriguez1325]

thank you! Your video was very helpful for my elementary statistics class. Wish I would have found it earlier.

[@Gosh220]

Thank you, it was very well explained.

[@XGCdisciple]

@NoHatinNoJealous I'm not sure exactly. On the chart toolbar there should be two buttons that say "By Row" and "By Column." Try messing with those to see if it gives you the same effect. I hope that helps!

[@Tikimit]

Thank you so much! I'm so glad you explain everything the way you do, it's so easy to understand and you don't rush through anything, keep it up! :)

[@seraphimman4524]

This was really helpful for my math project! Thanks so much! :D

[@airbornecrazykiller]

Thanks a lot! You even mention about outliers!!

[@Hudsonvidiocracy]

Thank you for my first lesson in box plotting data

[@zeroevident]

Bless your heart. You saved my life.

[@MissLynn87]

This is a GREAT video, thank you so much for putting this up! love it

[@karishmasaro0oo0p98]

THANK YOU THANK YOU SOO MUCH FOR THIS.. WAS VERY VERY HElPFUll IN ANA ADD MATH PROJECT I HAD !!

[@SwornSister]

thanks, it helped me even when im using the newer version

[@ayanuam111]

very good video. self explanatory

[@denkelsdrake6869]

The best stuff, really helped me this morning to earn 40 dollars

[@MrSconry]

Sweet! Nicely explained.

[@omarihno23]

dude this was great, how else do you want to improve that!!
thanks a million

[@korinemangtamag1700]

Oh My Gosh John!!!! You save my life thank you thank you....

[@sufi8961]

So so so helpful... Thanks alot.

[@manavgill77]

thank you this really helped me!!!

[@ktm3936]

Thanks for the tutorial! It was very helpful.

[@swee1movie]

holy shit i love you this will be handy for my assessment task

[@kyyyyylie]

Awesome awesome awesome explanation!! Thanks heaps John. You've saved me!!!
I am required to do a side by side whisker plot, how do I get them both onto the one plot? I hope this makes sense.. (If you still check this site?) :) Thank you heaps!

[@OskarJalkevik]

Very good video. It realy helped me!

[@gemvillasis2731]

thanks this video was incredibly helpful for my math ia!!

[@adityakumarbarik9289]

Thanks to share this video...it is Really Very helpfull.......

[@hieuluckyluke]

Thank you so much for instruction

[@xxxbramxxx]

your video is great, but i have one question, i tried to make this one by myself but i came with 15.325 for Q1 and 21.475 for Q3. could you please give me the formulas you used? thanks

[@GH-xo2pm]

Yes, I have the same problem with this video.
But it looks like he isn't answering questions. :/

[@faanpantsang6401]

It is very useful!!!!!!!!!!!!!Thank you so much!!!!!!!!

[@sarakerr16]

Most helpful video of them all. :)

[@exzot.1110]

thanks a lot! that was really useful!

[@KiddDyna]

THIS WAS AWESOME

[@MsDonnanana]

Thanks so much! You are awesome.

[@akavam]

you saved my life! thanks

good video. thank you very much. its very useful

[@noobgamer2340]

little hard to understand at first - at first, it was fine later :) - but it really helped thanks

[@ThePatrickhennessey]

Really useful, thanks

[@silverbutterflies814]

So helpful thank you

[@brunoborges3866]

Thanks for the help.

[@mee3ing]

Thank you so much for the video :)

[@kobechung5083]

thanks so much! you were really helpful

[@angelreyes32]

This helped me soo much!, THANK YOU! :)))

[@caviper1]

Clever. Thanks for sharing.

[@joettar]

Very well done!! Excellent!

[@ThePokerfacor]

really awesome video:)
my friend wanted to manually do this on paint-.-

[@100rly]

Great Video! Thanks!!!

[@sajpaj67]

excellent video!

[@cooliefosgal]

thank yo soo much.. so helpful..

[@LifeofChet]

Thank you so much!

[@Galinsky007]

We love you!

[@YsL0110]

Marvellous Job (: Brillant Thanks!!

[@MsSarahle10]

Thank you soooooo much ^^

[@ikickknowledge]

Great Video!!!!!!!

[@TheFalafelKing101]

THANKYOU SO MUCH OMG LOVE YOU!

[@zetaonly0088]

thanks !!! useful!!!

[@MrJason1234]

Thank you so much

[@PikachoRules]

THANK YOU SO MUCH!

[@sibnathbhattacharya4454]

Very helpful....thamk u so much

[@LpLaker805]

awesome video.

[@DaeNguyen]

this is very helpful! thank you so much~!!

[@ericoksenh]

Hi John, great video but I have a problem when using several covariates to do the last step (right whiskers). I can only choose a common value for all covariates which is not accurate. When I select only one box I have no more access to the function ...
Help !!! Eric

[@vikash8811]

Thanks a lot!!!!!!!

[@janarth13245]

The best!

[@alicec123]

thanks so much!

[@XGCdisciple]

@TRael90 I'm sorry but I do not know. If I had a mac to play around with I could try and see but I dont. Sorry to take so long to get back to you. Good luck, I'll post anything I find

[@TRael90]

Awesome Vid!!! But I have office 2008 for mac ugh. Way different.. would you by chance know how to figure this out on office for mac?