 difficult to draw like a histogram if you're going to do it kind of by hand. So the box and whiskers possibly is maybe a little bit more outdated although it's still a nice visual effect here and then next time we'll get into the comparison of it and kind of like the histogram. So let's go into the box and whiskers there we have it and boom. So now we've got this pictorial representation and I'll put it, I'll just put it right here for now. I'm going to get right into some more kind of idea of what exactly the box and whiskers is doing but for now let's format this. I'm going to get rid of the title at least for now. So remember we can format these items, I messed it up, delete the title, make it a little bit bigger, notice if I'm off the chart, I'll try to make it a little bit bigger this way, then I don't have those two tabs up top. If I go on to the chart just like we saw with our bar graph we get these two tabs up top. So with the chart design you've got the add chart elements, you know the axisies and so on, the quick layouts, you've got the color changes and what not that you can do to it and everything, blues the standard so usually you probably want to change it from blue if you're trying to impress somebody because otherwise they're like yeah you just picked the standard one and you could change it, you could change these, this is an easy way to change it as well. Here's your data sets, so if I go into my data sets we can see the data that was pulled in, if we edit the data set you can see the data set in this format that we pulled in to the box and whiskers and if you wanted to add another data set have two on the same graph for example then you can add it this way, that's one way that you can kind of add a data set. So and then change the type, you've got the formatting up top and this gets more into like the formatting stuff, the formatting selection, how you're going to, the shape fills and all that kind of stuff within your, now this just so you know that gets a little bit confusing when you look at the formatting because you're like hey some of that stuff is kind of repeated possibly over here in the home page but when you're working within a chart or graph you're typically going to want to go to the formatting on the right hand side which is specific to it. Now if I click on any of these elements within it, so if for example I have a lot of empty space back here which is kind of squishing up the box and whiskers up top, so I might say hey look can I just start this thing maybe at like 50 or something like that and take it up to like 85 maybe and then it'll be a bigger thing. So one way I can do is I can click in here and that will give me on the right hand side if I go to the right hand side I'm on my axis, so if I select the axis here, so now these are the numbers that I'm kind of working that I'm focused in on, so the minimum is at zero. What if I pull that minimum up to like 50, so now it went from auto it didn't just auto assign it I forced it to start at 50, so now it started at 50, so we don't have all that blank space we have a little bit wider of a box and then I can maybe I'll put the top at like 85,000 and so now we have a little bit wider of a pictorial representation. Now you have your other formatting options over here with the you know the shadow and the glow that's more kind of of the formatting I won't get into that in too much detail at this point but if you wanted to you know change some of those elements any of the elements within here you can click on these elements and again you could go into the information that is related to it in particular we also have the plus button so that gives us our axisies so if we want to label the axisies we probably don't need this one down here right so I could probably remove the one and so so this is the axis title now on this one I again I probably don't need this axis maybe but I might want like this axis to be you know wages or maybe I just put the title you know as wages since it's a box and whisker and then I can if I go into these chart title data labels this could be helpful depending on how large the item is right so we can add the labels to it and that can give you a sense of exactly you know what is going on and then the legend which would be applicable if you had like multiple data sets that that you were working with so so that's the general idea so next time we'll get into more detail exactly you know what what this is saying and we'll basically tie it out with the reason I don't want to get into it in detail now is because we can like do the math with it and we can do a formula to see exactly what is going on so we'll pick up you know quartile one quartile to the median the average and what the outliers basically mean and how exactly they are calculated and once you have a sense of that then it'll be easier to kind of just intuitively look at this however at this point I also just want to note that we could put multiple box and whisker charts which might be a useful tool in one area so let's go ahead I'm gonna I'm gonna copy and paste the data set over here to column R and then make a simple formula just to make another data set just so we can see that what that comparison might look like so if I go and if I select this entire column I'm gonna put my cursor on a so the drop down so now the entire column all the way down is selected I only need it down to the end of the table but this is a way to copy the whole thing I can right click and I can copy it and then I'm gonna move over here to column R so I'm in column R and then I'm gonna put my cursor on R1 I can't put it on R2 by the way because if I did and I try to paste it on R2 there's not enough room because I copied the entire column even though I only really