How to Make a Line Graph in Excel

Learn how to create line charts in Microsoft Excel with this step-by-step tutorial for beginners. As full disclosure, I work at Microsoft as a full-time employee.

Find out how to insert a recommended line graph. Also, learn how to insert a line chart directly and edit the horizontal and vertical axes.

Use this chart type to show trends over time (years, months, and days) or categories.

In this tutorial, I use Excel that comes with Office 365; however, this should also work with all previous versions of Excel, like Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and Excel 2003.

Access the sample data in the spreadsheet here:

[MEXTguide_yoyo]

I struggled around for hours to acheive what you managed to explain in less than 10 minutes and thanks to your explanation also managed to get what I wanted done in a much much much shorter time than I did while floundering around for this or that. My ignorance aside, thanks so much this has been super helpful!

[calebcannon]

I am glad that youtubers like you exist, cause with you I'd probably fail C.A.T. (Computer Applications Technology). South Africans love your videos.

[hellowaves]

You make it so seem so easy, thank you very much for all your time and effort you put into these videos.

[alexross]

i hate excel. i tried to do exactly this and it doesnt work

[yoyokanamihue]

THANK YOU!!!! Took me half an hour to give up and 5 seconds to follow yours!

[PerfectMo]

literally the first tip you gave helped me. 1:00
I was stuck for a good min and the one they recommended was the one i needed. Thank you

[noriahtalib]

It is always easy to follow your tutorial. Thank you very much

[babs]

how do i put three graphs together in one graph... i'm trying to put three data sets all in one for my econ class and can't seem to do it. Can you pls help me?

[peterrivera]

Amazing! Once I inserted the graph per your directions I took it to a new level with the myriad of available customizations. Thank you for your subject matter expertise.

[lorettarodman]

That combo was a life saver for my fly report thank you magic Kevin

[ItsSaraMackenzie]

I could cry learning about recommended charts :, )

[michaelpeele]

This was extremely helpful! THANK YOU!

[rimatabrah]

Kevin you made my entire day easier ☺️

[alamore]

REALLY HELPFUL thank you! Demystifying excel in a clear simple way.

[aliturnbull]

Good video, man. Almost exactly what i was looking for!

[thewashhouse]

excellent video to the point no nonsense!

[aykutyldz]

thank you very much for this helpful tutorial

[mikeprovost]

Thank you for this. You made it super easy.

[alexandriarinaldi]

Thank you so much, it was really helpful

[santosgiri]

Can you please show negative slope and r squared value as well ?