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
is some sort of data. Preferably you'll have a data where you have one variable that goes up
in increments. So either this could be age or date or
some other variable that increases at regular intervals.
The next piece of data that you'll need is some associated data with that increase in variables. So we're
going to pretend that this is data for a furniture store. And there's sales numbers throughout the month of January.
So we're going to say January 2024. And that's what all these dates are. And then all of these
numbers are their sales data for that day. It looks like they didn't really have a great month.
If you've ever worked in a furniture store before, these are these are a little low.
So let's go ahead and make our line graph. The first thing we'll need to do is select our data.
And now we'll go to insert 2D line, and we want this line graph
here. There we go.
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
we want Axis titles,
and we've got other options here for data labels, a table, error bars, we're not
going to really use any of that. We want to keep our chart pretty clean today, but we will add
titles over here. So this is sales, and this
Axis title will be the date. Now let's change
the color of our line by selecting the line,
and then this little fill bucket over here will let you select different options for the line, so we can have a
solid line, no line, automatic. The automatic line will always look like this.
Let's make it green because green is money. Okay, now we can change
different things about our line here, we can give it end to arrows, but we're
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.
a line graph in Excel.