This shows you how to make a Box and Whisker plot in Excel 2016 for Mac. There is now an automatic chart but these look nicer.
Пікірлер: 59
@StoleYourSnowman4 жыл бұрын
I referenced you in my research paper because I wouldn't have gotten the right graphic representation without this 😄 thanks
@Atsydo10 ай бұрын
Used your method of doing a box and whisker in my recent publication (In press). Thank you, this method rocks!
@laurynp98864 жыл бұрын
This is a very helpful video, especially since the version of excel I am using is older and does not have the box and whisker function. Thank you!
@figenozcan75365 жыл бұрын
thank you for making it manual rather than just selecting "Box and Whisker Chart" option. By this way, I was be able to prepare it in Excel 2010.
@adrianpardoblacutt52494 жыл бұрын
Glad I found you! I was searching for this all day... you're amazing! Thank you!
@rogzcorpuz3 жыл бұрын
Thanks, Maggie. This is what I need for my presentation next week.
@Bijlxmsth4 жыл бұрын
Thank you so much, you made it really simple and it was really easy to learn.
@lashwrithe013 жыл бұрын
Thank you so much. I have been trying to figure this out for a week!
@Pattocommissorio4 жыл бұрын
Thanks Meggie, great work! cheers from Italy
@cake_baker6 жыл бұрын
Thank you, you made it very easy to follow
@muhdnurhilmibinhermanto52735 жыл бұрын
Thank you very much....it's really help me as a student
@xx_trapzx29293 жыл бұрын
This is such a cool way of doing it! Very effective!
@arigunawan43145 жыл бұрын
Thank you.. the best tutorial
@asiyatasneem3983 жыл бұрын
Very easy and simple explanation excellent thank you
@BDQUERY3504 жыл бұрын
thk u so much!! I love uuu , greetings from Peru! (south america)
@HaliaEastburn3 жыл бұрын
Thank you! So easy to follow.
@yon3214 жыл бұрын
This was very helpful, thank you :)
@citlallym55123 жыл бұрын
Such a lifesaver, thank you so much ;;;;;;;;;;
@_alexambroz2 жыл бұрын
Very helpful, thank you!
@BeeaaHtiiS4 жыл бұрын
Thank you loads for the video! I much rather do it manually from now on!
@ricpxt4 жыл бұрын
FANTASTIC!
@InDiGoMeStYlE5 жыл бұрын
WOW MAGGIE WOW THANK YOU FOR EXISTING
@simonehanisch75484 жыл бұрын
THANK YOU SO MUCH SO THIS VIEDO !!!!!HELPS ME A LOT=)
@joaocunha94165 жыл бұрын
Thank You Very much!!!
@toqamanasarah44624 жыл бұрын
It is now available as one of the charts.Just update your version.
@lourdestan11455 жыл бұрын
Thank you!
@richieg.31923 жыл бұрын
Having trouble scaling the axis did you ever figure it out or post a video about it?
@michellehenderson19234 жыл бұрын
This is really good especially if you need to have a log axis. The excel function for box and whisker plots doesn't do that. Thank you for this video!
@jerrardliu13243 жыл бұрын
Thank you miss you save the day
@caissa61873 жыл бұрын
thank you!
@XtianLinares4 жыл бұрын
Lifesaver! But, how do I make Sample 1 and Sample 2 different colours? It only allows me to change the colours of Boxes 1 and 2, but I want to compare a test to a control and would like them to be different colours.
@ruselferrier63634 жыл бұрын
thanks this made me not hate math as much.
@johnmlendvay70215 жыл бұрын
Hello, Hello, Maggie! This was wonderful and I might add refreshing and bit hilarious!
@valentinonoah83023 жыл бұрын
i realize Im kinda off topic but do anyone know of a good website to stream newly released series online?
@matthewzachariah97793 жыл бұрын
@Valentino Noah i use FlixZone. Just search on google for it :)
@creeddarian1083 жыл бұрын
@Matthew Zachariah Yup, I have been using flixzone for since april myself :D
@valentinonoah83023 жыл бұрын
@Matthew Zachariah Thank you, signed up and it seems to work =) I really appreciate it!
@matthewzachariah97793 жыл бұрын
@Valentino Noah You are welcome =)
@jasminenava15203 жыл бұрын
What is the hit the "Command" button to keep cells active?
@elmerdecamps74673 жыл бұрын
Control (Ctrl) button
@bboyrickoshea Жыл бұрын
Hi I'm having an issue at 2min 50sec. After you highlight, how do you command? I'm not sure if its a Mac issue but I can't seem to complete this part of the tutorial. Any help would be appreciated as this tutorial has been amazing so far.
@terranceaye16293 жыл бұрын
I have Negative whisker not touching Box 2, there was a gap, what could be the reason,? My data have (+) and (-) values
@eballeng4 жыл бұрын
you saved me
@asheshsamaroo62202 жыл бұрын
where is the "command" function she said in the video?
@mlacorte213 жыл бұрын
HI Maggie, thank you for sharing this video it is extremely helpful! I was wondering if it would be possible to plot a set of points on the whisker plot so that someone could highly the data compared to the box plot. Example if you wanted to see the point 9.7 in sample 1 on the chart Thanks!
@asheshsamaroo62202 жыл бұрын
the online version of 365 is extremely limited and doesnt even have the "Chart Design" tab needed to make the box plot. Great video tho
@henriqueellrich57863 жыл бұрын
Ms Maggie, why you do it this way, and not using the default Whiskers and plot that excel shows? By selecting the data you want and create the plot? Thank you
@kenara3 жыл бұрын
When you make it by hand you have more control over the final results. When you select the default, it doesn't look as good and you can't make as many changes to the appearance.
@thanaye51153 жыл бұрын
Can we go directly to Box n whiskert chart option
@maggiewinslow21623 жыл бұрын
There is an automatic chart but these look nicer and have more options for changing the look.
@sebooz49494 жыл бұрын
in some tutorials here in youtube, they tell differently, they make minimum is minimum but you calculated their differences, which one is true Im not sure now....:( Im confused, of course I see what you do but everybody does different
@finisherone13 жыл бұрын
This won’t show you outliers though.
@diannegerald66764 жыл бұрын
what command she taking bout
@17Jahseh174 жыл бұрын
idfk
@apas77713 жыл бұрын
The command button on your keyboard. I am not sure about other companies, but Apple laptops have one on the right and left side of the space bar.
@a.fleischbender76816 жыл бұрын
There is a Chart type called "Box and Whisker chart". You don't need to make it manually....