Hello and welcome to a video on how to make scatter plots in Excel. Today we'll be making this scatter plot.
The first thing we'll do is select the data that we'll be using for our scatter plot. I'm selecting RIV1 and
RIV2 from the data set. Then I'm going to scroll all the way back up to the
top so you can see that I've selected all of these two columns.
Next we'll go to insert and we'll choose the scatter plot button
and we want just a simple scatter plot. You can see there's other kinds, but we want just a
simple scatter. And you can see
our other scatter plot up here has a red line of best fit. So we're going
to add that by clicking the chart elements plus button and then clicking trend line.
And now we can click on this trend line and format it. I right clicked
on the trend line and selected format trend line. I'll do that again.
By clicking this little paint bucket icon, we can now change the color of our trend line.
We can also make it a little wider, let's make it two points.
We can change our dash type to a solid line. And if we wanted to add arrows at
the beginning of our trend line, we could. But in this case, we don't really want arrows.
The next thing I'd like to add to my scatterplot are X and Y axis labels. So we'll click the
axis title button under chart elements. And that will give us a place to put axis
titles. We'll
call this one R_iv1
and R_iv2.
And that's it. That's everything you should need to know about how to make a scatterplot in Excel. Have fun!