 You have the dropdown, it's only selecting the data. So I could click that way and it selects the data, but really I want the whole table. So if I double click here, it selects the whole table and then I can drag that to the right, which is what I want, right? I want the whole thing. So I'll include the headers in it, and as I input the table, it should be able to determine what is the header versus the data. All right, so then we're just gonna go to the insert tab. We're gonna go to the charts group. We're gonna go to the dots here, and then I'm just gonna do the standard scatter. So there's the scatter. I'll pull that over to the right and let's pull this cell to the right a bit, and I'm gonna go over a bit more and we'll make it a bit larger. And so there we have it. So let's check this thing out. So I'm gonna remove the title. And so now it's gonna be important to kind of list. You kind of, the axis these titles are very important here because we've got to be determining what did it plot on the X down here versus the Y. Now you can get an idea for this because if I go to the horsepower and I sort it from Z to A, it's going to 230. So 230, clearly this side of the X is the horsepower. That's typically how it will be. If you sort your data with the X axis on the left and the Y on the right in the columns, it'll basically automatically then create the scatter plot in the format that you want. So then we can then go in here and say, let's add the axis titles. So there's, these are gonna be important. So down here we have the horsepower. Notice if I click on it, I'm not really inside it. It doesn't really remove the title here. But if I start typing, I can see it's showing up up here. So if I type in horse power, then it, then it types in. And I believe you can actually use a formula too. I could just say this equals the horsepower from there. And then now you have a nice link. So if I changed the title name or something, it would change. So that's probably a more efficient way to do this. And so I could say this one equals, you can see the equal sign up top, the miles per gallon. And so now we've got the miles per gallon. So there we have it pretty straightforward. Now, if I wanted to look at or change the dataset, I can go into here. Now, if I'm off of this, just like all of our other charts, I don't have my added tabs up top. If I go into the chart, now I've got the design and format tabs. If I go into the design tab, I've got the adding of the elements, the access, the access titles, many of these also being shown in that plus button. I've got the quick layouts here. So we've got the adjustments of the layouts if we wanted to test out these kind of custom layouts. We've got the color changes that we can put into play. Again, we have different kinds of formats of the layout here. If we wanted to pick those, if we want to switch the columns, switch the columns in row, and then the select data. So I want to select the data. And so this one might be a fast way sometimes to swap the data over the accesses. But if I go to the data here, we can see the data. So now we've got the miles per gallon. And over here, if I go to the edit and go into the edit, so we have the series name, this is the X and this is the Y. So the X down here, this access is here. So if I select this item, I could see what is in the X. If I wanted to swap them, this is one place I can go to switch them. If I wanted to switch them, I can say this would be the miles per gallon on the X and then the horsepower on the Y. But because we put it in this format, it pulled it in properly in the proper format. So that looks good. The X and the Y looks like what we would expect. And then you have your formatting tools over here as well. All right, so let's take a look at this side. If I go into my plus button, I've got the access. I've got the access titles. I've got the chart title. And if you have the accesses, the chart title might not be as important. I mean, you could have a chart title, but the most important thing here is that you want to make sure that you're putting the access titles oftentimes, because that's gonna tell people what's actually happening. Whereas in the histogram, and you only have one set of data, you might not need the access titles. You could just put the chart title. So if you need the data labels you can put here. Obviously, if you have a whole lot of data, this is gonna be quite tedious. I'm gonna add it for now just so we can kind of tie it in over here just to check it out. The error bars, so you could see, again, they put the little barn whiskers here. That could be useful if you don't have a whole lot of data. It would be not as useful if you have a whole lot grid lines. The legend, if you have multiple sets of data, then you could put a legend in, but we don't need one because we only have one thing that we're comparing to it miles per gallon. We have one, I should say, independent variable. And then the trend line. Now the trend line is something that's quite common, right? So usually when we do something like this, we're gonna wanna add the trend line. So that puts a line, an approximation through the data. Let's get rid of the numbers again. Those numbers, that's too much. Data labels, grid line, get rid of those, okay. So now we've got this line through the data. Now oftentimes we're gonna want that line to be a little bit more defined. So if I could double click on that line, or I could go on into the more detail from the plus button, and that gives us our information over here. So notice we have a linear line. That's usually what we want. You can test out the different line shapes here that might fit your data more precisely. And one of the ideas here, of course, is to say, what I'd like to have is a line that I can have a function for, right? I wanna have, it'd be nice to have a line that I can create a function for that fits the data, so that then it's easier to do mathematical kind of approximations if you have a line. A straight line would be the easiest one, but some kind of line that you can have a mathematical equation for would be useful sometimes. Now sometimes it's nice to actually have the equation. So if down here it says display equation, so if I go into the equation, that gives us our equation for the line. So I'll make that a little bit larger so you can kinda check it out. Let's go up top and say that I'm gonna increase the size of that thing. So, and obviously again, if we have the equation for the line, then we can kinda try to use that equation to make approximations and so on even though the line is just an approximated line, just basically going through the middle of the data to try to look at a trend through it. So if I go into that line again, the other way you can get into that line is hit the plus button and then in the trends, I got that linear line. I wanna open it back up again. So let's actually go down here to more options. So now I've got that in place. Now if I go to this bucket on the left, sometimes I would like to see that line as a different color quite often. Let's make it red, which will make it stand out. And then is that the color of the line didn't turn red? Let's go to red here on the line and then here we've got these styles of the line. I'd like to make it an actual line. So now I've got a line instead of the dots. So there we have it. That's some of the main items that we would be adding. Now, just to get an idea of this, if we have the horsepower here, remember this is kind of the independent variable and what you would expect then as the horsepower goes up, the miles per gallon goes down, which is kind of what we see here, right? So we're gonna say that as the horsepower, if I sort this from A to Z is low, so lower horsepower between 40 and like 60 over here. So horsepower is going up from 40 to 60. If I look at the miles per gallon related to that, we start to go down, right? So it's starting to trend down as the horsepower goes up, which is kind of what you would expect in general. And then as you get the horsepower up to like 100, then the miles per gallon are going down. And then as you increase the horsepower, the miles per gallon are going down. And then when you get way out here to really high horsepower, so if I reverse this from Z to A, and I'm looking at like the 230 plot over here, then you can see for some reason, the miles per gallon is actually a little bit higher than some of the ones prior to that. And you can start to look at something like this and say, well, why would that be the case, for example? I don't really know.