How to Make a Line Graph in Excel - From Simple to Scientific

Want more Excel videos? Here’s my Excel playlist: • Excel for Beginners: E... This video will show you how to make a line graph in excel. Charts are quick to create in Microsoft Excel. In this tutorial, I will show you how to create a line graph to show a trend and a scatter graph with scientific data to compare. Also included is how to copy a graph from Excel over to Microsoft Word for a research paper or PowerPoint for a presentation.
Subscribe to Teacher's Tech: bit.ly/Subscribe_TeachersTech
Learn how to use Microsoft Excel for beginners here: • Microsoft Excel Tutori...
Excel for beginners level 2: • Microsoft Excel Tutori...
Microsoft Excel Tutorial - Level 3: • Microsoft Excel Tutori...
Learn Pivot Tables for Beginners: • Excel Pivot Table Tuto...

Пікірлер: 124

  • @callsignpanzer7209
    @callsignpanzer72095 жыл бұрын

    I love your videos, I always stay tuned to the newest ones and I love the way you teach I really hope to see you grow into the millions!

  • @gatorgrowl7325
    @gatorgrowl73254 жыл бұрын

    Thank you so much. Simple and straightforward; exactly what I was looking for.

  • @pablo6570
    @pablo65705 жыл бұрын

    Thank you for making this video, I needed to make a line chart quickly and it helped me do it.

  • @theonlyonewitch
    @theonlyonewitch4 жыл бұрын

    Absolutely amazing tips, very convenient to manipulate your document different ways. Thank you for making this video.

  • @weiping869
    @weiping8694 жыл бұрын

    This is so useful, helped me alot with my school's assignments , thank you so much !!

  • @anitac2017
    @anitac20172 жыл бұрын

    Hi! Thank you very much for this video. It was EXACTLY what I needed to make some graphs for my school science experiment report; this video helped me very much. Just one thing for others who might be after the same thing (the "Scientific" graph/Scatter with smooth lines and markers graph): it didn't show an instant preview for me the way it did in the video, instead, I had to click "More Scatter Charts..." at the bottom of the drop-down there (4:45), and then there you can click on the one that's an instant preview of your data. Thanks again!

  • @amirwafi7403
    @amirwafi74033 жыл бұрын

    That linking towards the end would've saved me so much valuable time when I did my degree

  • @hey_itsmele
    @hey_itsmele4 жыл бұрын

    THANK YOU SOOOO MUCH! THIS WAS VERY HELPFUL!

  • @shicks1998
    @shicks19984 жыл бұрын

    Thank you, for the information, it helps me so much.

  • @IyanuloluwaTimothy
    @IyanuloluwaTimothy Жыл бұрын

    This the best, detailed video I have seen on this topic. Great job, thank you!

  • @keithduff5971
    @keithduff59712 жыл бұрын

    Awesome! Exactly what I was looking for. Thanks so much!

  • @ashleynguyen3393
    @ashleynguyen33933 жыл бұрын

    Thank you so much for your tutorials. For an Gen X like me, this is face savings since I don’t have to call around for help on how to put together a graph. 😄

  • @kjskjs52
    @kjskjs524 жыл бұрын

    Thank you for the lecture~! :) It's been very helpful~!

  • @uclalse
    @uclalse4 жыл бұрын

    Thank you! This was such a helpful overview of what is possible to do.

  • @sgsumanshu

    @sgsumanshu

    4 жыл бұрын

    You may also want to give a try to the following playlist of 3 videos, which helped me a lot while preparing my lab report using excel and word. I thought it is worth sharing that here kzread.info/dash/bejne/q5yW2c2iaMLUo6w.html

  • @keithjames4182
    @keithjames41823 жыл бұрын

    Great tutoring i even wonder how people dislike such elaborate knowledge.

  • @wellengoncalves7469
    @wellengoncalves74693 жыл бұрын

    Saved my life today! Thank you so much!!!

  • @TeachersTech

    @TeachersTech

    3 жыл бұрын

    You're welcome!

  • @mbogoteresia8346
    @mbogoteresia83462 жыл бұрын

    Exactly what I was looking for💯Thank you

  • @anthonyellis5977
    @anthonyellis59772 жыл бұрын

    Thanks heaps mate, your a legend

  • @shishirgurung5158
    @shishirgurung51583 жыл бұрын

    Thank so much... i have been learning a lot from you all the time. God bless you.

  • @xoxoxoxo2564
    @xoxoxoxo25643 жыл бұрын

    Thank you. This is really helpful. Want to learn more about Excel.

  • @bernardleehk
    @bernardleehk Жыл бұрын

    Thanks for making this video. It is clear and easy to understand. Thanks!

  • @EstebanGuzmanV
    @EstebanGuzmanV4 жыл бұрын

    Thank you so much for the explanation. I love you men !!!

  • @PrinceofTEXAS
    @PrinceofTEXAS Жыл бұрын

    Thank you so much, I appreciate how you made this task simple to learn.

  • @jnxm0728
    @jnxm07283 жыл бұрын

    Thankyou so much! God bless you!

  • @lindseysexton6564
    @lindseysexton65646 ай бұрын

    This was very helpful. Thank you.

  • @TeachersTech

    @TeachersTech

    6 ай бұрын

    Glad it was helpful!

  • @krose29743
    @krose297433 жыл бұрын

    Nicely done. Thanks!

  • @tongriangben-ameh6753
    @tongriangben-ameh67533 жыл бұрын

    Thank you! This was a lot of help.

  • @552003orchid
    @552003orchid3 жыл бұрын

    Thank you! Your video is very helpful

  • @ivanobodovskyi9535
    @ivanobodovskyi95357 ай бұрын

    Great video! Thank you, Sir!

  • @FlippedClassroomTutorials
    @FlippedClassroomTutorials5 жыл бұрын

    Great video as always. Loving the different visuals Microsoft gives us! Also these graphs look great in a OneNote Notebook!

  • @TeachersTech

    @TeachersTech

    5 жыл бұрын

    Great point, Sethi! I really like all the different ways OneNote can be used.

  • @troyicus1136
    @troyicus11364 жыл бұрын

    GREAT Video. Subscribed.

  • @Blasphemer_Cosmos
    @Blasphemer_Cosmos Жыл бұрын

    Always a pleasure to study from your videos sir

  • @jimmaskell3199
    @jimmaskell31994 жыл бұрын

    Thank you so much! Couldn't figure out how to make a graph with an inconsistent x-axis. Turns out I was just using the wrong graph!

  • @aykutyldz1538
    @aykutyldz15382 жыл бұрын

    thank you very much for this extremely useful tutorial

  • @AlexK-lm1xt
    @AlexK-lm1xt2 жыл бұрын

    Great tutorial!

  • @dadamine3263
    @dadamine32633 жыл бұрын

    liked it very much thanks Sir

  • @nirmithrjain6265
    @nirmithrjain62653 жыл бұрын

    Thank you so much, very helpful

  • @mitchclark8848
    @mitchclark88484 жыл бұрын

    Absolute Legend

  • @svijayiitk
    @svijayiitk4 жыл бұрын

    Wow, thanks:)

  • @geetkaur2343
    @geetkaur23434 жыл бұрын

    Hi, Thank you so much ,I Love your videos its help me alot in my work i request you please upload if function video .

  • @pwarrow
    @pwarrow3 жыл бұрын

    Wow i am just a student and i learned alot from this video awesome work keep it up and have a great day.

  • @khaliscain4549
    @khaliscain454911 ай бұрын

    Wow this was so helpful this was the most well explained video out there thank you so much this will help a whole bunch. :)

  • @tutorialshop7670
    @tutorialshop76705 жыл бұрын

    Good content keep it up

  • @alisonleung9057
    @alisonleung90573 жыл бұрын

    Thank you.Good to learn graphs in science LAB.

  • @parso9276
    @parso92764 жыл бұрын

    what a gun, you really helped thanks :) :)

  • @ccwashington626
    @ccwashington6269 ай бұрын

    EXCELLENT Instruction!!! I feel like I should be paying you tuition. 🤣

  • @raquelortizgarcia8168
    @raquelortizgarcia81683 жыл бұрын

    Thank you!

  • @srijakar1016
    @srijakar10162 жыл бұрын

    THANK YOU VERY MUCH, SIR

  • @board-qu9iu
    @board-qu9iu4 жыл бұрын

    Thank you for making this video. It was very useful and easy to do.

  • @vaijnathkale6000
    @vaijnathkale60003 жыл бұрын

    thank you so much its so helpful and valuable

  • @parkourkid1234
    @parkourkid12343 жыл бұрын

    thanks! you just saved me

  • @sunnymann9639
    @sunnymann96394 жыл бұрын

    BEST Video ever

  • @bhavikapathak1513
    @bhavikapathak15133 жыл бұрын

    Thank you..

  • @altobyy4855
    @altobyy48553 жыл бұрын

    thanks. it really helped

  • @dghatt3491
    @dghatt34913 жыл бұрын

    Very helpful

  • @BubblesPothowari
    @BubblesPothowari6 ай бұрын

    In Gratitude, Thank you !! fm a person in 8th decade

  • @TeachersTech

    @TeachersTech

    6 ай бұрын

    You are so welcome

  • @harksfishing7936
    @harksfishing79363 жыл бұрын

    Helped so much thanks!

  • @TeachersTech

    @TeachersTech

    3 жыл бұрын

    You're welcome!

  • @mrfranktaylor
    @mrfranktaylor5 жыл бұрын

    Thanks

  • @papajatan7010
    @papajatan70104 жыл бұрын

    that you i am a 13Yr old it helped me alot thanks

  • @sickfukpatrol1983
    @sickfukpatrol1983 Жыл бұрын

    THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! its been 10 fucken years since i have needed to use this lol kids just stay in collage ok?

  • @waleedbarghouty6564
    @waleedbarghouty6564 Жыл бұрын

    Thank you for all your effort! BTW, the sound in this video is low!

  • @cezarcelik4813
    @cezarcelik48133 жыл бұрын

    Multumesc fra

  • @MrMclovinIam
    @MrMclovinIam3 жыл бұрын

    The sound is really low on this video... Great content!

  • @sunnymann9639
    @sunnymann96394 жыл бұрын

    OMG LOVE U

  • @ranadebray5440
    @ranadebray54402 жыл бұрын

    Thank you for the above example with the excel template, but I am not able to draw the S shaped line graph. May you please let me know how do I draw a line graph?

  • @hahahoodgoboom4778
    @hahahoodgoboom47783 жыл бұрын

    Yes now I will pass my geography.

  • @monporoshneog4725
    @monporoshneog47253 жыл бұрын

    Pls make a detail video on how to plot Live data in graphical form.. for example- time vs change in A PRICE. THANK YOU

  • @pandulenilucas7177
    @pandulenilucas71773 жыл бұрын

    Great videos! Are you only make videos of excel? I have a problem of finding IP address and calculations

  • @sandraputman8854
    @sandraputman88544 жыл бұрын

    Informative although the audio is low and one can zoom into the steps to have a better view of the options chosen in every step

  • @kelvinmemeh
    @kelvinmemeh4 жыл бұрын

    Thank you , very informative. I have a question. How do I show what a point on the Y axis corresponds to on the X axis.Say for instance say I have a line graph showing weight and age of children in school. The plot is a straight line. The Y( vertical axis) has the Age and the x ( horizontal) axis has the Weight. If I wanted to show using a line that a particular Age on the Y axis correspond to a weight in the x axis, how do I show it ? ThnX!

  • @rdyjur

    @rdyjur

    4 жыл бұрын

    follow his example. instead of Profit and Year in the Y and X axes, respectively, you want Age and Weight, respectively. Personally, I think you should use a Scatterplot for that but it should work.

  • @LavonYoung1
    @LavonYoung13 жыл бұрын

    Would you make videos on formulas?

  • @ronaldrainero7098
    @ronaldrainero70984 жыл бұрын

    Since when did excel make this super complicated. I used to just highlight it and it would make it automatically

  • @alexabatecola5735
    @alexabatecola57352 жыл бұрын

    Are you able to move the line on the graph and have it change the table numbers?

  • @arshikhan5136
    @arshikhan51362 жыл бұрын

    Sir , would you plz make tutorial on Job's plot ,how to draw it step by step

  • @rdyjur
    @rdyjur4 жыл бұрын

    line plot is just a less intuitive scatter plot. Change my mind ? is there any benefit/features of a line plot that I can't achieve with a scatterboi ?

  • @iamdenislara
    @iamdenislara4 жыл бұрын

    4:49 why his maps shows many lines: blue, orange and gray? mine is a single line

  • @dhanushka1461
    @dhanushka14613 жыл бұрын

    can you explain how to plot the negative and positive values in excel

  • @doubleoakridge
    @doubleoakridge3 жыл бұрын

    Great video I’m still having an issue on my 2015 MacBook Pro I am unable to move the data to the graph it keeps giving me a blank display any suggestions

  • @7777AAng
    @7777AAng5 жыл бұрын

    Do you have a tutorial on pivot tables? Thank you!

  • @TeachersTech

    @TeachersTech

    5 жыл бұрын

    Working on one to release later this week.

  • @7777AAng

    @7777AAng

    5 жыл бұрын

    @@TeachersTech Looking forward to it! Thanks!

  • @muffidge

    @muffidge

    5 жыл бұрын

    @@TeachersTech Easy to follow video as usual. Looking forward to Pivot Tables :-)

  • @ab_microverse
    @ab_microverse2 жыл бұрын

    How can we switch the axes in graph after creating graph?

  • @saucyglock7341
    @saucyglock73414 жыл бұрын

    Does anyone know how to make a graph that you can zoom in to it and out?

  • @neemambilinyi8555
    @neemambilinyi85558 ай бұрын

    👏👏👏👏👏👏👏

  • @ginogigiki5649
    @ginogigiki56494 жыл бұрын

    How to make a line graph including all data points but showing only selected points... e.g. Take in account all years data for something but just show every 5 years... BUT THE LINE TAKES IN ACCOUNT ALL YEARS POINTS TO MAKE THE LINE? If I use the filter it excludes the data from the years I don't like to show up in the graph though I need them

  • @sgsumanshu

    @sgsumanshu

    4 жыл бұрын

    You may also want to give a try to the following playlist of 3 videos, which helped me a lot while preparing my lab report using excel and word. I thought it is worth sharing that here kzread.info/dash/bejne/q5yW2c2iaMLUo6w.html

  • @charbelkaram4142
    @charbelkaram41423 жыл бұрын

    Thanks for the video but I have a problem. In x axis, the numbers are not the numbers that I want

  • @tommy7451
    @tommy74514 жыл бұрын

    This is what I was looking for to learn graphing.... BUT I can't hear it... and yes all the volumes are turned up as high as they can go.....

  • @CinemaTeacher
    @CinemaTeacher5 жыл бұрын

    Great video! But volume is too low 😁

  • @mikemccants8719

    @mikemccants8719

    4 жыл бұрын

    I thought it was my computer

  • @user-vj2lq3sn7c
    @user-vj2lq3sn7c3 жыл бұрын

    بكرة عندي امتحان 😭😭 هاي مينArmy💜💜💜💜

  • @sisandakhoza2752
    @sisandakhoza27524 жыл бұрын

    thank you soo much I was starting to panic

  • @alessiaperodi678
    @alessiaperodi6783 жыл бұрын

    When i select the data, and choose line graph...the line doesnt appear and none of my data points are what I typed in...

  • @emilgeorgiev1074
    @emilgeorgiev10744 жыл бұрын

    why you dont put the standart Deviation

  • @Gattsu_the_struggler
    @Gattsu_the_struggler3 жыл бұрын

    It keeps creating two lines for me rather than the x and y axis

  • @meanieeheart4236
    @meanieeheart42363 жыл бұрын

    im in class rn

  • @PremKumar-gu8cz
    @PremKumar-gu8cz3 ай бұрын

    I understand what you are saying. Not sure for example. Show a little more clearly

  • @phoebe6853
    @phoebe6853 Жыл бұрын

    This does not work. My data does not appear on the graph when I select is. It's stressing me out of my mind!

  • @johnslayer6712
    @johnslayer67124 жыл бұрын

    mine won't start at zero only 1 and all data is on y

  • @sgsumanshu

    @sgsumanshu

    4 жыл бұрын

    You may also want to give a try to the following playlist of 3 videos, which helped me a lot while preparing my lab report using excel and word. I thought it is worth sharing that here kzread.info/dash/bejne/q5yW2c2iaMLUo6w.html

  • @username-dh4tq
    @username-dh4tq Жыл бұрын

    #trimuda :

  • @kgn8766
    @kgn87665 жыл бұрын

    I can't hear it!!

  • @sgsumanshu

    @sgsumanshu

    4 жыл бұрын

    You may also want to give a try to the following playlist of 3 videos, which helped me a lot while preparing my lab report using excel and word. I thought it is worth sharing that here kzread.info/dash/bejne/q5yW2c2iaMLUo6w.html

  • @awhig2474
    @awhig2474 Жыл бұрын

    isn't the Volume TOOOOOOOOOO LOW !!!

  • @thanasisbokos8257
    @thanasisbokos82574 жыл бұрын

    Your Uncle

  • @meghanviola3037
    @meghanviola30372 жыл бұрын

    I want to listen... but I can't.... I just CAN'T!!!!