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

แชร์
ฝัง
  • เผยแพร่เมื่อ 14 ม.ค. 2025

ความคิดเห็น • 125

  • @callsignpanzer7209
    @callsignpanzer7209 5 ปีที่แล้ว +28

    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!

  • @anitac2017
    @anitac2017 3 ปีที่แล้ว +2

    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!

  • @wellengoncalves7469
    @wellengoncalves7469 4 ปีที่แล้ว +1

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

  • @amirwafi7403
    @amirwafi7403 4 ปีที่แล้ว +7

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

  • @gatorgrowl7325
    @gatorgrowl7325 4 ปีที่แล้ว +6

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

  • @hey_itsmele
    @hey_itsmele 4 ปีที่แล้ว +6

    THANK YOU SOOOO MUCH! THIS WAS VERY HELPFUL!

  • @lindseysexton6564
    @lindseysexton6564 ปีที่แล้ว +1

    This was very helpful. Thank you.

  • @anthonyellis5977
    @anthonyellis5977 3 ปีที่แล้ว +1

    Thanks heaps mate, your a legend

  • @ivanobodovskyi9535
    @ivanobodovskyi9535 ปีที่แล้ว

    Great video! Thank you, Sir!

  • @uclalse
    @uclalse 4 ปีที่แล้ว +3

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

    • @sgsumanshu
      @sgsumanshu 4 ปีที่แล้ว +1

      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
      th-cam.com/video/yhbwki8_nsI/w-d-xo.html

  • @krose29743
    @krose29743 3 ปีที่แล้ว

    Nicely done. Thanks!

  • @AlexK-lm1xt
    @AlexK-lm1xt 3 ปีที่แล้ว

    Great tutorial!

  • @bernardleehk
    @bernardleehk 2 ปีที่แล้ว

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

  • @IyanuloluwaTimothy
    @IyanuloluwaTimothy 2 ปีที่แล้ว

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

  • @pablo6570
    @pablo6570 5 ปีที่แล้ว +6

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

  • @tongriangben-ameh6753
    @tongriangben-ameh6753 3 ปีที่แล้ว

    Thank you! This was a lot of help.

  • @nirmithrjain6265
    @nirmithrjain6265 3 ปีที่แล้ว

    Thank you so much, very helpful

  • @dadamine3263
    @dadamine3263 3 ปีที่แล้ว +1

    liked it very much thanks Sir

  • @PrinceofTEXAS
    @PrinceofTEXAS ปีที่แล้ว

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

  • @shishirgurung5158
    @shishirgurung5158 4 ปีที่แล้ว

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

  • @jnxm0728
    @jnxm0728 4 ปีที่แล้ว

    Thankyou so much! God bless you!

  • @vaijnathkale6000
    @vaijnathkale6000 3 ปีที่แล้ว

    thank you so much its so helpful and valuable

  • @harksfishing7936
    @harksfishing7936 3 ปีที่แล้ว

    Helped so much thanks!

  • @mbogoteresia8346
    @mbogoteresia8346 2 ปีที่แล้ว

    Exactly what I was looking for💯Thank you

  • @weiping869
    @weiping869 4 ปีที่แล้ว +2

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

  • @aykutyldz1538
    @aykutyldz1538 3 ปีที่แล้ว

    thank you very much for this extremely useful tutorial

  • @552003orchid
    @552003orchid 4 ปีที่แล้ว

    Thank you! Your video is very helpful

  • @FlippedClassroomTutorials
    @FlippedClassroomTutorials 5 ปีที่แล้ว +6

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

    • @TeachersTech
      @TeachersTech  5 ปีที่แล้ว +1

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

  • @kjskjs52
    @kjskjs52 4 ปีที่แล้ว +2

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

  • @Lord_of_Cosmos
    @Lord_of_Cosmos 2 ปีที่แล้ว

    Always a pleasure to study from your videos sir

  • @theonlyonewitch
    @theonlyonewitch 4 ปีที่แล้ว +1

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

  • @raquelortizgarcia8168
    @raquelortizgarcia8168 3 ปีที่แล้ว

    Thank you!

  • @xoxoxoxo2564
    @xoxoxoxo2564 4 ปีที่แล้ว

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

  • @keithVTUMD
    @keithVTUMD 3 ปีที่แล้ว

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

  • @altobyy4855
    @altobyy4855 3 ปีที่แล้ว

    thanks. it really helped

  • @sunnymann9639
    @sunnymann9639 4 ปีที่แล้ว

    BEST Video ever

  • @ccwashington626
    @ccwashington626 ปีที่แล้ว

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

  • @pwarrow
    @pwarrow 4 ปีที่แล้ว

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

  • @troyicus1136
    @troyicus1136 4 ปีที่แล้ว

    GREAT Video. Subscribed.

  • @khaliscain4549
    @khaliscain4549 ปีที่แล้ว

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

  • @srijakar1016
    @srijakar1016 2 ปีที่แล้ว

    THANK YOU VERY MUCH, SIR

  • @EstebanGuzmanV
    @EstebanGuzmanV 4 ปีที่แล้ว

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

  • @waleedbarghouty6564
    @waleedbarghouty6564 ปีที่แล้ว +1

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

  • @dghatt3491
    @dghatt3491 4 ปีที่แล้ว

    Very helpful

  • @keithjames4182
    @keithjames4182 4 ปีที่แล้ว

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

  • @parkourkid1234
    @parkourkid1234 4 ปีที่แล้ว

    thanks! you just saved me

  • @kevinballou7822
    @kevinballou7822 หลายเดือนก่อน +1

    Hey Teachers Tech, Im having a little issue with the line graph based on my data. I have the data up in the chart perfectly but after following you instructions to the tee, I dont have the plus that allows me to add axis titles to the X and Y sections. I am currently making this for an assignment for my Health Informatics major. Im not sure what version of excel I have currently but any advice would be appreciated.

  • @shicks1998
    @shicks1998 5 ปีที่แล้ว +1

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

  • @alisonleung9057
    @alisonleung9057 3 ปีที่แล้ว

    Thank you.Good to learn graphs in science LAB.

  • @iamdenislara
    @iamdenislara 5 ปีที่แล้ว +3

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

  • @geetkaur2343
    @geetkaur2343 4 ปีที่แล้ว +1

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

  • @tutorialshop7670
    @tutorialshop7670 5 ปีที่แล้ว +1

    Good content keep it up

  • @board-qu9iu
    @board-qu9iu 5 ปีที่แล้ว +2

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

  • @bhavikapathak1513
    @bhavikapathak1513 3 ปีที่แล้ว

    Thank you..

  • @pandulenilucas7177
    @pandulenilucas7177 3 ปีที่แล้ว

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

  • @papajatan7010
    @papajatan7010 4 ปีที่แล้ว +1

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

  • @cezarcelik4813
    @cezarcelik4813 4 ปีที่แล้ว

    Multumesc fra

  • @ashleynguyen3393
    @ashleynguyen3393 4 ปีที่แล้ว

    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. 😄

  • @jimmaskell3199
    @jimmaskell3199 4 ปีที่แล้ว +2

    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!

  • @mitchclark8848
    @mitchclark8848 4 ปีที่แล้ว

    Absolute Legend

  • @LavonYoung1
    @LavonYoung1 4 ปีที่แล้ว +1

    Would you make videos on formulas?

  • @MrMclovinIam
    @MrMclovinIam 3 ปีที่แล้ว +1

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

  • @parso9276
    @parso9276 5 ปีที่แล้ว +1

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

  • @ronaldrainero7098
    @ronaldrainero7098 4 ปีที่แล้ว +9

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

  • @BubblesPothowari
    @BubblesPothowari ปีที่แล้ว +1

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

  • @monporoshneog4725
    @monporoshneog4725 3 ปีที่แล้ว

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

  • @svijayiitk
    @svijayiitk 5 ปีที่แล้ว

    Wow, thanks:)

  • @mrfranktaylor
    @mrfranktaylor 5 ปีที่แล้ว +1

    Thanks

  • @arshikhan5136
    @arshikhan5136 3 ปีที่แล้ว

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

  • @alexabatecola5735
    @alexabatecola5735 2 ปีที่แล้ว

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

  • @km_surg
    @km_surg 5 ปีที่แล้ว +1

    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.

  • @doubleoakridge
    @doubleoakridge 3 ปีที่แล้ว

    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
    @7777AAng 5 ปีที่แล้ว

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

    • @TeachersTech
      @TeachersTech  5 ปีที่แล้ว +2

      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 :-)

  • @hahahoodgoboom4778
    @hahahoodgoboom4778 3 ปีที่แล้ว +2

    Yes now I will pass my geography.

  • @sandraputman8854
    @sandraputman8854 4 ปีที่แล้ว

    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

  • @ranadebray5440
    @ranadebray5440 3 ปีที่แล้ว

    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?

  • @dhanushka1461
    @dhanushka1461 4 ปีที่แล้ว

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

  • @sunnymann9639
    @sunnymann9639 4 ปีที่แล้ว

    OMG LOVE U

  • @neemambilinyi8555
    @neemambilinyi8555 ปีที่แล้ว

    👏👏👏👏👏👏👏

  • @sickfukpatrol1983
    @sickfukpatrol1983 2 ปีที่แล้ว

    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?

  • @ginogigiki5649
    @ginogigiki5649 5 ปีที่แล้ว +2

    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
      th-cam.com/video/yhbwki8_nsI/w-d-xo.html

  • @ab_microverse
    @ab_microverse 3 ปีที่แล้ว

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

  • @rdyjur
    @rdyjur 4 ปีที่แล้ว

    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 ?

  • @charbelkaram4142
    @charbelkaram4142 4 ปีที่แล้ว

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

  • @alessiaperodi678
    @alessiaperodi678 3 ปีที่แล้ว

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

  • @وردةبيضاء-ت6ك
    @وردةبيضاء-ت6ك 3 ปีที่แล้ว +1

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

  • @saucyglock7341
    @saucyglock7341 5 ปีที่แล้ว

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

  • @CinemaTeacher
    @CinemaTeacher 5 ปีที่แล้ว

    Great video! But volume is too low 😁

  • @emilgeorgiev1074
    @emilgeorgiev1074 4 ปีที่แล้ว

    why you dont put the standart Deviation

  • @tommy7451
    @tommy7451 5 ปีที่แล้ว

    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.....

  • @Gattsu_the_struggler
    @Gattsu_the_struggler 3 ปีที่แล้ว

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

  • @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!

  • @sisandakhoza2752
    @sisandakhoza2752 4 ปีที่แล้ว +1

    thank you soo much I was starting to panic

  • @johnslayer6712
    @johnslayer6712 4 ปีที่แล้ว

    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
      th-cam.com/video/yhbwki8_nsI/w-d-xo.html

  • @kgn8766
    @kgn8766 5 ปีที่แล้ว

    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
      th-cam.com/video/yhbwki8_nsI/w-d-xo.html

  • @meanieeheart4236
    @meanieeheart4236 3 ปีที่แล้ว

    im in class rn

  • @PremKumar-gu8cz
    @PremKumar-gu8cz 8 หลายเดือนก่อน

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

  • @meghanviola3037
    @meghanviola3037 3 ปีที่แล้ว

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

  • @awhig2474
    @awhig2474 2 ปีที่แล้ว

    isn't the Volume TOOOOOOOOOO LOW !!!

  • @username-dh4tq
    @username-dh4tq 2 ปีที่แล้ว

    #trimuda :