 all the way over here somewhere in like BP and I'm going to right click and I'm going to paste it just one two three I don't really need the formulas so I'll just paste it one two three so there's just our data that we made we could also and it might even be safer by the way to do this with it with a formula like so so instead of doing it that way let's let's show you another way we can do it I'm going to undo that I could say I'm going to start here in BP and say equals and then I'm going to point to that data set so then if I changed my data set this graph would change with it so I'm going to point to this number in E 17 notice when I scroll over you can still see where where you know the formula bar up top and if I hit enter it'll bounce me back over here and then I can copy this to the right so this is actually a reference in E 17 copy that to the right and then I'm going to copy these two cells down I'm just going to go until I don't have any more data so I'll just copy it down and it's still going it's still going like that bunny with the battery in it uh we'll keep on rolling till the battery runs dry and the bunny falls over and puts his head his head goes right through the drum that he was banging because he ran out of power so let's go up top and then make this a little bit larger okay so that's that's our our first data set so now if I was to if I was to select that data and insert and let's put a header on it I'm going to select these two I want to put something above it so I'm going to insert cells above it so I'm going to select those two right click insert and then shift the cells down so see I say I'm going to call this the men's data set and we'll make that our headers home tab fonts group let's make it black and white so and maybe I should put the men over here because I'll try to use the same columns too but and then I could make a uh a bar chart out of that our hiss our bar chart histogram that we made before I can take this data and say I want to scroll up and insert then the not the histogram but the bar chart which will make in essence a histogram like thing so there we have it so we did that in the prior presentation now we want to take the data set the second data set for the women and put them on this same chart so make this nice and wide and so now we want to take the second data set so let's start by doing the same thing I'm going to make a a skinny br let's make a skinny br and I'll pull this to the right and then I'm going to put my cursor in bs and say equals and I'm going to pull in the data set from the women so I'm going to go on over here the buckets that we put together for the women in a prior presentation are down here so here's our bucket sizes so we'll take these buckets 57 uh to and then to 57 52 enter I'm going to copy that to the right copying it to the right Roger that copy out Roger that's uh airplane speak in case you don't know as a pilot so then I'm going to copy this down and we're going to copy this down and so so there we have those so those have been copied down now I want to line up these two buckets so notice this one is starting uh at 57 so for the men I'd like to kind of push this down until it until it gets to the 60 so this line in other words I want to line up that line with this line 60 60 28 this one so how can I do that well I could select the whole thing and pull it down I could insert cells I can cut and paste let's try inserting cells so I'm going to select from here to here and then I'm going to insert cells above it which should pull these down so that's this is the way that I think is most unintuitive to most people but highly useful so I'm going to right click and insert and then I want to shift the cells down so I'm going to say shift the cells down now notice that it formatted it like the cell above it on these blank ones if you hit just undo then it usually undoes just the formatting or sometimes it does I'm going to redo it it didn't do it that time and sometimes it also has that little formula bar but you can also just I'm going to put my cursor on some other cell that doesn't have any formatting in it home tab clipboard paint brush and then I'm going to paint brush this formula okay so so so there we have it now let's add the extra the extra buckets here I'm going to put them on the men's side adding the extra buckets so there's our buckets where the men have zero I'm going to put zeros in the men's data for those buckets so now I'm going to be using this as my x because it has the buckets which are going to be useful for both the men's and women's data and then I can pick up these two data sets men and women here so we'll make this black and white so now we need to adjust our data so if I click in the data you'll see that we're not including this stuff over here so the easiest way to do that is we can we can click on it and see the and just drag these up so now we're picking up the data and the columns now if if the other way you can do that is you can go to the chart designs and select data and you'll see here's the data series so if I go into that one and go into my data it's picking up this column and then on this side these are the buckets right so you can see it's picking up the buckets okay so now we want to add what we want to do is add now the woman's data which is properly lining up to the same buckets so all we need to do is add another data series I don't need to add the buckets because the whole trick here is that the buckets are lining up for both of them we have the same x side so now we can line up our two y's uh in our in our chart so the way to do that is we can or we can go into our chart again chart design and I want to say select data and now I want to have another series of data on the left