 then down and then control backspace so that we got the data properly selected and then insert tab and charts and we want to go to the scatter and scatter boom so now we've got our our trend so I'm gonna delete this and then we got to say okay which way are the X's and Y's going because I lined them up this way I would expect this to be the X right this would be the X side you kind of check by looking at the bottom and top so it goes from 0 up to 50 so if I sort this from Z to a like alright goes up to 50 that kind of makes sense this one only goes up to 30 if I sort this from Z to a that kind of makes sense so it looks like this one is the miles per gallon which is what we would expect I'm gonna hit the plus button here and say that I want access titles put my cursor in the access title equals the miles per gallon no this one is the acceleration and then this one equals the miles per gallon we can add a trend line so now this one is trending upwards you can see that was what I was trying to get a trend line going the other way this one trending down this one's trending up we're gonna say plus button trend line I want a linear trend line more options and then I could say that I would like to see a formula for it so let me check out the formula there's our formula can make that a little bit larger home tab on the formula increase in the size of it pulling it up somewhere so we can actually see it and then back to this trend line and let's say that we want to make it let's say let's say we just want to make it glow right if I leave it at that same like color but then I go down here and say and say let's go to the glow and give it that that yellow glow so now you now you've got that trend line that's not really covering anything up but you can still kind of see it and maybe I'll do a different glow we saw yellow before let's do an orange so there we have that and so so there's that relationship now let's build this one more time but this time taking the information from the table on the left so now I'm going to go to the table and I'm gonna select miles per gallon so I'm gonna try to do the easiest way to select these two columns at the same time the most intuitive way is to put your cursor here and drag all the way down because you want to make sure that you you select all of the data and not the entire column but I think the faster way when you have a lot of data I'm gonna close this out is to put your cursor here control shift down taking you to the bottom of the data holding control backspace taking you back up then I'm holding control down to select the other cell so I have non adjacent cells cells that are not next to each other selected at the same time and then holding control shift and down to get the two columns you might also try by the way I'm gonna go control backspace putting your cursor just on this one and then this holding control and this one so now I've got these two non adjacent cells by holding control and then hold down control shift and down but then it really only hits the second one so you can then control backspace I'm gonna put my cursor here and then control shift down to get both of them holding control backspace alright so you can experiment with different ways to do that but going back up we're gonna go to the insert tab the the charts and make the good old scatter and before you enter the scatter by the way you might want to position where you want it to go right so I might try to kind of move over here even though I still have those other ones selected so that the scatter hopefully will be generated somewhere over here right so I can go insert and then charts and then give me the scatter and so now it's I can just drag it right here so it kind of put it in the middle of the screen where I'm currently viewing you know which is nice and so then I can just do my standard thing here I'll do it fast because we've done it a few times and we're running long on time so we're gonna say that let's add some axes so the chart title the axis titles so this is gonna be equal to and I'm gonna say the miles per gallon and then this axis scrolling to the right this axis is equal to we're gonna say the acceleration acceleration going back to the right and then we can add a trend line if we so choose trend line linear more options we want this to be we want to see the formulae down here give me the formulae there it is let's make it larger home tab I gotta be selected on it home tab font group increasing the font size grabbing it pulling it up a bit clicking on that trend line so now I have the trend line information on the right and I'll go to the bucket and this time let's change the color of the trend line to like orange maybe and then make it glow middle tab glowing it's nice when stuff glows and it's the green glow green and blue do I think that's not good for color blindness is it I don't know I'm talking about and let's make it that I did orange before well we'll just do the same so I'm gonna close that out so that's the general general idea of the scatters