Hello, and welcome to a video on how to make box plots in Excel. So to make any kind
of chart, you'll first want to select your data. In this case, today let's make a box
plot for IV2. So we're going to select just the data from IV2.
Okay, I've gone ahead and selected all that data. And I'm going to scroll back up to the top so that my box chart appears closer
to the top. Next you'll go to insert, insert
statistics chart. This may look a little different depending upon your version of Excel. But look
for either statistics chart or box and whisker plot something along those lines. And you see we've found an option
for a histogram and for a box and whisker plot. In this case we want box and whisker.
Okay, I'm just going to move this off to the side a little bit. Let's change
this chart title to something else. And you can see when I double click it we've got title options. We can have it overlay.
I don't like that though. You can't see your title is clearly. So we'll stick with above. We
have text options. So we can choose our alignment. We can have
shadow color, text fill.
We're not going to do any of that today. Generally speaking, when you're talking about data visualization,
simple is best. We'll just title it Lindsey's box plot today. Or maybe
just my box plot. Your assignment will have a specific name that you'll be naming
your box plot. Now this one down here is a little bit useless. So you can just
click on this one and hit your delete key to get rid of it. If you
do not have a delete key, the backspace key will probably work just as well. Now you'll notice we have these
little buttons off to the side. And you'll have these on almost every chart style that Excel has
available. And you can click these and add chart elements. So if we wanted axis titles,
then that's where we would click to add those. If we didn't want a chart title, we could get rid of it that way. But we do want a
chart title. If we wanted data labels, we could add them here. And this would
let us know what exactly the numbers are for our outliers, for our quartile
percent, sorry, quartiles, our inter quartile range, things like that.
We can have a legend, which we only have one series, so having a legend is a little silly. Let me go ahead
and change my title back to my box plot. Now, if for some reason
this isn't showing up right here, you do also have the option to add chart elements over here.
And you can do a quick layout to quickly change how your chart appears.
We can also change the colors of our chart.
Let's make it lighter blue or maybe orange.
Yeah, orange looks nice. We'll go with orange. We can also reselect our
data. If we decide, oh shoot, this isn't the data that I wanted. You could
change it here. Let's say we want a DV instead.
Click ok and now we can see that our box plot has updated to select
DV instead of IV2. We can also change our chart type and
move our chart. So if you needed it to be on a different sheet, then you could select
it and move it to a new sheet in your workbook. Generally
speaking, it's best to put your things in the sheets where they belong in the first place and not move things around
too much, but if you need to move something then you absolutely can. Okay,
that's it. That's all you need to know about box plots to do your assignment. Have fun learning.