1
00:00:00,000 --> 00:00:01,033


2
00:00:01,033 --> 00:00:07,233
Hello and welcome to a video on how to make scatter plots in Excel. Today we'll be making this scatter plot.

3
00:00:07,233 --> 00:00:10,166


4
00:00:10,166 --> 00:00:16,266
The first thing we'll do is select the data that we'll be using for our scatter plot. I'm selecting RIV1 and

5
00:00:16,266 --> 00:00:21,899
RIV2 from the data set. Then I'm going to scroll all the way back up to the

6
00:00:21,900 --> 00:00:22,700


7
00:00:22,700 --> 00:00:28,566
top so you can see that I've selected all of these two columns.

8
00:00:28,566 --> 00:00:29,599


9
00:00:29,600 --> 00:00:35,700
Next we'll go to insert and we'll choose the scatter plot button

10
00:00:35,700 --> 00:00:36,366


11
00:00:36,366 --> 00:00:42,399
and we want just a simple scatter plot. You can see there's other kinds, but we want just a

12
00:00:42,400 --> 00:00:42,433


13
00:00:42,433 --> 00:00:48,433
simple scatter. And you can see

14
00:00:48,433 --> 00:00:54,699
our other scatter plot up here has a red line of best fit. So we're going

15
00:00:54,700 --> 00:01:00,166
to add that by clicking the chart elements plus button and then clicking trend line.

16
00:01:00,166 --> 00:01:01,266


17
00:01:01,266 --> 00:01:07,599
And now we can click on this trend line and format it. I right clicked

18
00:01:07,600 --> 00:01:13,833
on the trend line and selected format trend line. I'll do that again.

19
00:01:13,833 --> 00:01:20,499


20
00:01:20,500 --> 00:01:26,433
By clicking this little paint bucket icon, we can now change the color of our trend line.

21
00:01:26,433 --> 00:01:27,199


22
00:01:27,200 --> 00:01:32,066
We can also make it a little wider, let's make it two points.

23
00:01:32,066 --> 00:01:34,066


24
00:01:34,066 --> 00:01:40,132
We can change our dash type to a solid line. And if we wanted to add arrows at

25
00:01:40,133 --> 00:01:40,166


26
00:01:40,166 --> 00:01:45,599
the beginning of our trend line, we could. But in this case, we don't really want arrows.

27
00:01:45,600 --> 00:01:47,033


28
00:01:47,033 --> 00:01:53,066
The next thing I'd like to add to my scatterplot are X and Y axis labels. So we'll click the

29
00:01:53,066 --> 00:01:58,832
axis title button under chart elements. And that will give us a place to put axis

30
00:01:58,833 --> 00:02:06,099


31
00:02:06,100 --> 00:02:12,600
titles. We'll

32
00:02:12,600 --> 00:02:12,933


33
00:02:12,933 --> 00:02:16,166
call this one R_iv1

34
00:02:16,166 --> 00:02:21,232


35
00:02:21,233 --> 00:02:23,366
and R_iv2.

36
00:02:23,366 --> 00:02:27,899


37
00:02:27,900 --> 00:02:33,100
And that's it. That's everything you should need to know about how to make a scatterplot in Excel. Have fun!