How to Create a Box and Whisker Plot in Excel 2010
Вставка
- Опубліковано 4 жов 2024
- Step by step instructions on how to create a Box and Whisker Plot in Excel 2010.
Note: This method doesn't work if the min, max, or any of the quartile values are negative.
Every year I watch this for a particular graph I make and every year I am thankful for you
THANK THE LORD YOU ARE HERE REIVE!! My statistics coursework would not have been the same without you!!!!
THANK YOU!!! I could never have done this without you. Seriously. Thank you. Thank you. I wish I could express (the inability to hug you really detracts from my thank you) how valuable your video has been to my life this evening. Seriously. Thank you. Seriously.
It is ridiculous that it takes this much work to make this plot in Excel but the video is totally logical and really helps work you through making a good looking box and whiskers plot
Thank you Mr Reive. Very clear and helpful. I feel accomplished now that I have constructed my box and whisker plot for my Business Analytics class which compares the petrol and diesel prices in cents per litre.
Much appreciation. Well done.
Thank you so much! Your tutorial has been the easiest to understand for people like me who is an English major! THANK YOU!!!!
Thank you so much! The night before my maths assignment is due and our teacher literally just told us to "figure it out by ourself, not my problem," so this video has probably saved my grade! You have the clearest and most understandable tutorial on this so THANK YOU AGAIN!!
Thank you! This really helped me with my a level stats work! And I agree with the other people, excel needs an option for this!!
Thank you!!! I couldn't have finished my maths assignment without this!! thanks a lot
Thank you so so much! I had an assignment for uni and had no idea how to do this or anything on excel. Your thorough explanation with your lovely american accent was amazing! Thanks heaps and heaps! :D
2024 😀 It was really helpful. the excel in my computer is 2010's and My data science teacher uses 2016's... thanks
hi Mr. Reive, just wanted to say that this was really useful video! Although I struggled with creating a chart for something with more than 2 boxes. This was due to labelling each box using the legend - I just didn't have enough colours to label each one! I found perhaps a better way of doing it - if you right click on the chart and go to "select data", you can label each plot via the Y axis by selecting "Horizontal axis labels" and editing to fit each box. I hope this helps others in my situation in just tweaking what is otherwise a very useful video!!
This video was extremely helpful and I just wanted to thank you for putting the time and effort to make this tutorial. Again, thank you very much!
Thanks for the tutorial. You did a great job at doing a step by step instruction. Excel should add this function into to its graph options.
Thanks for the comment. I agree, Excel should have this as a graph type. Maybe they will add it in the future.
My God! this video saved my life! thank you so much for this useful video...!
Well that's 13 minutes of my life that I'll never get back...
This was a HUGE help for my stats class. Thank you so much.
Thanks - you've made me a legend at the office. For a moment. But it was a good moment :-)
Nevermind, just saw another comment with the same question. Thanks for the video, super helpful!
Thanks alot, this is the first time i'm seeing this video, helped me alot, especially in my School Based Assessment
Thank you so much!!! Your video helped me with my project. God bless you!
THANK YOU!!!! Absolute life-saver. Really great and detailed tutorial. Easy to follow.
Thank you so much! This video was really helpful to finish our school math project :D
thx, helped me clutch up my stat final research project
This is super amazing thank you for making this! It worked. It took forever but looks fantastic! Thank you so much!
Thanks, but I actually figured out how to do it using your method. You can't do it in order, ie. min to Q1 to Median and etc..., but if you arrange the negative values from least negative to most negative then from least positive to most positive and then take the difference it works out nicely. Hope that helps someone else!
THANK U A LOT!! I can never figure it out without this video. It is so helpful! Wanna give u a super hug for your brilliant video!!!!! And by the way your voice is quite nice!!
This was so useful. I needed to know how to make these for my AP Stats project, and I couldn't figure out how.
Thank you so much for this video! It was so helpful to me to watch while I created my own for my course :)
Thank You that was pretty perfect. I have a mac running office 2011. Only difference was adding the borders. I did this by changing glow.
Thanks for the guide. Excellent Description.
Thank you sooo much! i needed this for my project and i couldn't figure out how to do it, this was just a life saver for me! :)
Glad it helped. Thanks for the comment.
what an incredible tutorial, respect!
Thank you so much for this video! You're a lifesaver
Miranda Phillips Another way to label the tests is to get rid of the ledged and use put the labels on the vertical axis. This will solve your problem because you can have a label for each test. At 12:10 in the video instead of removing the axis, double click it and type your labels in.
This is exactly what I wanted. Thanks for the video. It was of great help!
thank u!!!! very helpful for my maths b assignment
I finally got it. I went to "More Error Bar Options" and had use a fixed value error bar and type in the difference from Q1 to min and from Q3 to max.
nichole flores The Switch Row/Column button is disabled when the 2 columns of difference data are not on the same rows. For example if the differences for data A is in B1:B5 and the data B is in D9:D13. In this case excel can’t switch Row/Column. Move or copy both difference data to the same rows but different columns, like B1:B5 and D1:D5 and everything should be fine.
+Mr. Reive Thank you sooo much was stuck in there for awhile ..
I love this video! Thanks for helping with my Maths SBA! :D
a lifesaver. truly thanks so much
Glad it was helpful. Thanks for the nice comment.
super useful! Thank you so much for the video! You helped me a lot for my maths assessment!
thankyou! helped me a lot on my lab report
I'm glad I could help. Thanks for the comment.
umm... mine will not let me do error bars? I clicked on the purple then went to layout and clicked error bars then error with standard, nothing happened?
Same problem...any solutions?
you saved my life man, thanks
Glad it helped. Thanks for the comment.
I have seen this before. Try this it should get you to the same place. Select the purple bars like at 5:13, then select the "Error Bars" tab like I do but go to "More Error Bar Options" at the bottom of the menu.That will get you to 5:28 in the video.
Mines too,not getting the error bars
Kat Hope same my error bars dont work. is there any fix ??
yeah i got it to work but i honestly can't remember how i did it
+Failzord WoW after clicking on the error bar button, go to more error bar options, click on plus or minus. That should work
Yo....I even tried doing that ^ but it didn't work. It's not appearing at all :( *sighs*
Thank you sooooo much for this video. Extremely useful.
Brilliant tutorial, saved my ass in my Uni assignment, it kinda works with negative values as you can see where values are meant to be on the graph, but very difficult to show that information neatly, wonder if there's a proper way of doing it though
Thank you for the video, it was tremendously helpful. Can you show us how to make a box and whiskers plot with outliers? My data clearly has outliers, as observed with a scatter graph. I want these outliers to be made clear in the box and whisker plot.
it's a great video, thanks. I have a comment though... The error bars shouldn't go to the min and max values. The upper error bar should stop at most extreme measurement within the upper inner fence. The upper inner fence is calculated using Q3+1.5(Q3-Q1). The lower inner fence is Q1-1.5(Q3-Q1), and the error bar should stop at the smallest measurement within the lower inner fence. The way the video is recorded, it's impossible to have outliers, since the max and min are included in the box and whisker plot.
Yes you are correct, this method doesn't allow for outliers.
For others, here is a nice site that explains how to do a box and whisker plot with outliers in the data:
hotmath.com/hotmath_help/topics/box-and-whisker-plots.html
very useful, thanks a ton. i loved its magic.
Your a life saver
Wonderfully helpful. I love you man.
Glad you got it to work. Thanks for posting the update.
This was so helpful, keep up the tutorials, Thanks
great video! Thank you!
Was a great help... Thank you! Meitaki Maata
WOW, THIS WAS SOOO HELPFUL! THANK YOUUUUUU
vary good presentation, it is helpful
That is the control button on your keyboard of a PC, I'm not sure what it would be on a Mac. When you hold the control button down and select cells with your mouse you will add to whatever you currently have selected.
THANK YOU. Fantastic. Great help for my University protect.
Saved my life, man!
Thank you. That was very helpful.
Without holding any keys on the keyboard down select the first column of differeces, let up the mouse button, hold the Ctrl button down, select the second set of differences with the mouse, then let the mouse button up and the Ctrl button up.
You are the real mvp
You could remove the legend then go to Layout->Axes->Primary Vertical Axes->Show default axes. You will see each plot numbered on the Vertical Axes. Click on the numbers, then right click & pick Select Data. Click on Edit above the numbers then select all of your names. The names should show up on the axes. Or remove the legend and use Textboxes, Go to Insert->Text Box and make a textbox for each name. I have seen it both ways, they both look good. Good luck.
thanks for the sharing!!! it helps me a lot!!!1
The only way that I can think of how to drop a line from a quartile value on the chart down to the axis is to use the line tool. Go to Insert -> Shapes -> pick line near the top. Now draw the line on the chart to where you want it. Right click on the line -> Format Shape to change the line color and other properties. But if you change the data you will have to redo the line. Hope this works.
Absolutely Brilliant
Thank you! Very easy to understand. Helped in the assignment and I put you in as a reference! :) Is there any way to compress the series 1?? I have no data in that section.
Life saver.
Thanks helped a bunch
Really great video! Keep up the great work!
AMAZING, thank you!
Thank you very much
The Switch Row/Column button is disabled when the 2 columns of difference data are not on the same rows. For example if the differences for data A is in B1:B5 and the data B is in D9:D13. In this case excel can’t switch Row/Column. Move or copy both difference data to the same rows but different columns, like B1:B5 and D1:D5 and everything should be fine. Hope this solves your problem.
okay thank you very much it really helped :)
i am working with excel 2007 and i was following all the steps correctly and everything was working fine but when i reached the step to insert the error bars i click the purple bar(i am working with one box&whiskers plot) and click the standard error bar thing. when i do this nothing happens.... any pointers?
oh and thanks for the quick reply :)
Thank you for the video! If you have 3 boxplots, what are you goiing to do with the colors?
Thank you. Very helpfull.
Thank you very helpful
i was wondering how can you change the intervals on the bottom to what you would like
great video
one question is there a way to place a line coming from the quartile/median to the axis itself?
thnx in advance
Awesome video! Question, it worked for me several times except when i got to a data set with a mix of negative and positive values. How do we handle those? I am actually making a box and whisker for a normal distribution. Thanks!
Thank you sooooooo much :)
Thanks! This really helped!
Great. Thanks, I'm sure that will help some people.
so helpful!!!!!!!!!!!
Hey, this was a very useful video. I was trying to get a whisker plot done for ages , this seems a good start. I tried doing what you did. I have 6 colours instead of 5 !! I have an orange on side of blue. Would you please tell me why this happens? Thanks well in advance.
ok thanks alot i played around with it finally got it. thnx for your help
it seems like every time u answer me i have a next question...i hope I'm not bothering you too much.
for my data i found the quartiles and the min and max using excel's formulae. then i did those things manually(by hand) everything matched up except for Q1 (by excel-Q1=10.25 manually-Q1=10). the formulae i used to work it out manually was Q1 position =1/4(n+1) where n is the number of values i have.
any pointers or help?
Thank you, so much!
Once you have the chart copied like I did at 12:18 then just go to your Word document, go to where you would like to paste the chart, then right click and paste. Pick one of the paste options that says "Embed Workbook" and the chart will print more clear and sharp.
THANK YOU SO MUCH!!
just awesome, thank you so much!!!!
Yes you are correct, sorry. One of my students ran into this too. I updated the description to add your comment.
Please explain all the keyboard shortcuts you do, because I had a very hard time following along
I used ctrl+c to copy and ctrl+v to paste a lot, those could be making it hard to follow. Also when I’m editing or looking at a formula and I want to click away without making changes I press the Esc key. If you don’t press the Esc key Excel will start editing your formula by adding the cells that you click on, this causes a lot problems with my students. Another thing I do when I’m making a formula is click on the cell with my mouse instead of typing it in. For example when I’m entering the formula =E5, I type the = then click on the cell E5. If I missed something let me know the time I did it and I will tell you what I have done. Good luck.
That cleared it up a lot! Thank you!
I don't have a design tab to use to switch rows and columns. So I can't figure out what you are doing at 3:50. Please help! Thank you
I clicked on "Standard Error Bar" and the bars did not show up. How do I fix this? All my values are positive.
Thanks Aubrey.