1
00:00:00,066 --> 00:00:02,099


2
00:00:02,100 --> 00:00:08,100
Hello, and welcome to a video on how to create a line graph in Excel. The first thing you'll need to create a line graph

3
00:00:08,100 --> 00:00:08,133


4
00:00:08,133 --> 00:00:14,133
is some sort of data. Preferably you'll have a data where you have one variable that goes up

5
00:00:14,133 --> 00:00:20,233
in increments. So either this could be age or date or

6
00:00:20,233 --> 00:00:20,266


7
00:00:20,266 --> 00:00:24,566
some other variable that increases at regular intervals.

8
00:00:24,566 --> 00:00:27,332


9
00:00:27,333 --> 00:00:33,499
The next piece of data that you'll need is some associated data with that increase in variables. So we're

10
00:00:33,500 --> 00:00:33,533


11
00:00:33,533 --> 00:00:39,999
going to pretend that this is data for a furniture store. And there's sales numbers throughout the month of January.

12
00:00:40,000 --> 00:00:40,966


13
00:00:40,966 --> 00:00:47,232
So we're going to say January 2024. And that's what all these dates are. And then all of these

14
00:00:47,233 --> 00:00:53,299
numbers are their sales data for that day. It looks like they didn't really have a great month.

15
00:00:53,300 --> 00:00:53,333


16
00:00:53,333 --> 00:00:59,233
If you've ever worked in a furniture store before, these are these are a little low.

17
00:00:59,233 --> 00:01:00,366


18
00:01:00,366 --> 00:01:06,866
So let's go ahead and make our line graph. The first thing we'll need to do is select our data.

19
00:01:06,866 --> 00:01:10,132


20
00:01:10,133 --> 00:01:16,133
And now we'll go to insert 2D line, and we want this line graph

21
00:01:16,133 --> 00:01:16,166


22
00:01:16,166 --> 00:01:22,132
here. There we go.

23
00:01:22,133 --> 00:01:24,133


24
00:01:24,133 --> 00:01:30,399
So now we have a couple of options for things we can do with our line graph. Let's try to make it match this first one. So

25
00:01:30,400 --> 00:01:36,633
we want Axis titles,

26
00:01:36,633 --> 00:01:40,933


27
00:01:40,933 --> 00:01:46,933
and we've got other options here for data labels, a table, error bars, we're not

28
00:01:46,933 --> 00:01:53,033
going to really use any of that. We want to keep our chart pretty clean today, but we will add

29
00:01:53,033 --> 00:01:53,066


30
00:01:53,066 --> 00:01:58,632
titles over here. So this is sales, and this

31
00:01:58,633 --> 00:01:59,499


32
00:01:59,500 --> 00:02:04,200
Axis title will be the date. Now let's change

33
00:02:04,200 --> 00:02:06,600


34
00:02:06,600 --> 00:02:12,100
the color of our line by selecting the line,

35
00:02:12,100 --> 00:02:12,866


36
00:02:12,866 --> 00:02:18,899
and then this little fill bucket over here will let you select different options for the line, so we can have a

37
00:02:18,900 --> 00:02:25,100
solid line, no line, automatic. The automatic line will always look like this.

38
00:02:25,100 --> 00:02:28,633


39
00:02:28,633 --> 00:02:34,533
Let's make it green because green is money. Okay, now we can change

40
00:02:34,533 --> 00:02:36,799


41
00:02:36,800 --> 00:02:42,866
different things about our line here, we can give it end to arrows, but we're

42
00:02:42,866 --> 00:02:48,899
not going to do any of that today. We're just going to leave it as a green line, and that's it. that's all you need to do.

43
00:02:48,900 --> 00:02:48,933


44
00:02:48,933 --> 00:02:49,933
a line graph in Excel.