Graphing two data sets on the same graph with Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ต.ค. 2024

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

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

    LITERALLY SAVED ME FROM FAILING MY . COULD NOT FIGURE OUT HOW TO PLOT THE DATA I WANTED . CANT THANK YOU ENOUGH

  • @severusschwarz8245
    @severusschwarz8245 6 ปีที่แล้ว +74

    Well this was super clear ,didn't have to watch it all to get what I was looking for ,well done.

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

      Yeah same here

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

      @@ecaterinagamez3314 yep same here aswell

  • @rarietyamor8803
    @rarietyamor8803 5 ปีที่แล้ว +38

    This man has saved me a lot of time to work on my post lab XD Thank you!

  • @HumbertoHernandez
    @HumbertoHernandez 16 วันที่ผ่านมา

    7 years in, and still helping the world.

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

    It's been about four years... still a great video. Thanks man.

  • @michaelazar8015
    @michaelazar8015 8 หลายเดือนก่อน

    Super clear, insightful, and straight to the point. Thank you so much sir.

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

    As Donald Trump would like to put it, this is probably one of the most insightful excel video tutorial in the history of excel video tutorials, maybe ever. You have explained the concept by a lot. Record explanation. You've done a great job.

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

    Blimey! You are a star. Thank you, thank you, thank you.Even though I am using a later version of Excel, I still found your explanations so clear, so straightforward and so easy to carry out.

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

    You make it sound so easy. I have known and used Excel since Office 97, but this is the first time I learned about plotting values.

  • @gordongrover4065
    @gordongrover4065 6 ปีที่แล้ว +2

    short and to the point. great job Clayton

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

    Yes, thank you so much Mr. Spencer. This worked for me; video was clear and concise. Other videos were so confusing.

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

    Thank you. I have been consistently trying to put all the data in at once. One line at a time. Great!!

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

    ive been looking for a video like this for the past 1 hour and finally found.Its very few channels or google searches that answered my questionand my assighnments due....thanks!!!!😍😊

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

    Thank you very much, it helped me a great deal without having to watch the entire video, this tells how precise it is.

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

    Thank you so much Sir..this was what I was searching for..many videos I got but no one was like this and could not get anything I needed from those..and your way of explaining is also fabulous Sir 🙏🏻

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

    thank you so much. my chem prof asked us to graph two sets of data without explaining it at all but this was so helpful. thank you!

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

    you saved my assignment. The video is so on point that got me to subscribe to your channel and hit the notification button too.

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

    Excellent video! Idk why Excel makes things so complicated, love you man 🔥

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

    Thank you very much. Not many people showed this kind of plot.

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

    Thank you very much Mr. Spencer. This was exactly what I needed.

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

    This guy is the actual 🐐

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

    If I ever see you, I'm gonna hug you :| Thank you sooooo much for this.

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

    Thank You mister for saving our physics graph

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

    This video was SO HELPFUL! Thank you

  • @5inafrica
    @5inafrica 8 หลายเดือนก่อน

    I've been looking for over an hour for how to do this! Thank you so much for explaining this so clearly (I only wish you had an updated version). Adding a line with my newer version of Excel doesn't seem to work the same way. :(

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

    Thankyou, Sir
    I have plot graph in my under-graduated project, case of 2 sample with a different horizontal-axis value
    This so helpfull, Gbu

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

    Thank you my kind sir. This helped me with my math modeling final project.

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

    You are a LEGEND for this video

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

    Clearly, and concisely explained. Thank you very much indeed!

  • @hannahtaylor1981
    @hannahtaylor1981 5 ปีที่แล้ว +12

    THANK YOU SO MUCH! Perfect job explaining this!!

  • @ecaterinagamez3314
    @ecaterinagamez3314 6 ปีที่แล้ว +2

    Thank you for this its very helpful! Clear, short, and precise tutorial

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

    Thank you! exactly what I was looking for.

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

    thank god for your video! many thanks! and you were on point for everything - not dragging out the video for view minutes

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

    Brilliant stuff straight to the point

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

    oh my days... thank you so much for your help!!! I appreciate this a lot!!

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

    Sir, your explanation is perfect thanks a lot

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

    Thank you. A FABULOUS EXPLANATION.

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

    you just saved my deadass sir...hats off

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

    Thank you so much! This was an easy to follow tutorial and saved me so much time.

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

    A million thanks to you.

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

    Wonderful, just what I was looking for! Thank you!

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

    This was very clear and concise , thanks!

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

    Thank you for the video, it was really clear and helpful

  • @fasdailhaq1193
    @fasdailhaq1193 4 ปีที่แล้ว +10

    idk my excel doesnt have series X/Y values edit, its only series name and " series values". Im using office 2016 pro plus.

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

      Instead of using the line graph, choose a scatter diagram. It'll show the X and Y series. You might also just insert the Excel file in word, they'll pop up.

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

    Thank you so much that was so clear and straightforward

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

    Most perfect explanation. THANKS

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

    i love you i dont understand why i never found usefule informations in polish language

  • @sureshbabu-jf8mj
    @sureshbabu-jf8mj 3 ปีที่แล้ว

    Awesome .Very well explained. Thanks a lot

  • @m.l.staple7824
    @m.l.staple7824 5 ปีที่แล้ว

    Thanks a billion.I wasted my time watching a bunch of other videos that were of absolutely no help

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

    You sir, have helped me tremendously for my kinetics and reactors course. Thank you !

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

    Just an observation, you sound a little bit like Dave Foley! Thank you for the great video.

  • @nusrateasmin9853
    @nusrateasmin9853 2 หลายเดือนก่อน

    Thank you so much ! It's a great help !

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

    Very helpful and easy to understand!

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

    extremely good helped me a lot thank you so much

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

    Thank you so much. It actually answered my question :D

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

    Perfect for chem. graph. Thank you very much.

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

    clutchest video ever (it's 1:36 am) So i cant ask the professor rn

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

    Amazing video. Very informative

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

    Thank you very much! The video is concise and clear.

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

    You the best !! My grade thanks you 🙏

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

    That was amazing. Super easy to follow thank you sooo much

  • @simbongilemflatelwa8895
    @simbongilemflatelwa8895 6 ปีที่แล้ว

    thank you so much that was quick and straight to the point

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

    this saved me so much time, thanks!

  • @khayalamimahlalela7904
    @khayalamimahlalela7904 6 ปีที่แล้ว

    Very useful sir. Highly appreciated!

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

    Really great video, super concise and useful :)

  • @jamie-joyjmj7233
    @jamie-joyjmj7233 5 ปีที่แล้ว +1

    YOU ARE JUST THE BEST EVER !!! MY GOSH!!! thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu!!

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

    Thanks champ, very helpful. I hate this assignment

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

    you deserve a big like

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

    Thank you...that's very helpful

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

    wonderful tutorial. Thank you!

  • @smoutezot
    @smoutezot 11 หลายเดือนก่อน

    How can you do this for classes (categorical variables) in a boxplot for example?

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

    That is really helpful...thanks

  • @horizonxxxl
    @horizonxxxl 6 ปีที่แล้ว

    That's very useful and simple enough, thanks!

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

    You saved my life !! Thank you

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

    Thanks for sharing, only your video did it help me from others on understanding the combo graphs. Thanks and God bless =)

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

    Thanks man your video really helped me out🤘🏻🤘🏻

  • @Ryan-ke3qd
    @Ryan-ke3qd 4 ปีที่แล้ว

    Great tutorial, thanks man

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

    how did you get the option to put in y-values?

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

    Awesome video
    Thank you

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

    Thanks very much. I've subbed. This will improve my life :D

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

    excelent video only one question
    I am not sure why in my version when i click the Select Data Option it only shoes me the X axis and the z axis to the left side would you know how can i change that?

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

    it was very good help
    Thank you

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

    Thank you very much,it helps me very much

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

    Very helpful - thank you!

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

    Thanks, Clayton!

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

    You're a gentalman thanks so much.

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

    Thank you clear explanation

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

    Thanks for this video. However, I have a question! Even though the number of data for both line is same, but here is difference in plot. To plot 2nd line, why excel take only 4 points instead of 6 points. Please make me clear. It will be highly appretiable. thanks in advance.

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

    Thank you very much ....it really helped me a lot🙏🤝

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

    Thank you this was really helpful

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

    when i click ADD on the select data box i get a pop up with two slots instead of three. Kindly assist.

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

    THANK YOU, this was extremely helpful

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

    Thanks most helpful

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

    Im just getting incorrect formatting errors even though I copied exactly what you did with the data I have for my project. I guess I'm just a special kind of stupid. Cause I dont get it at all.

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

    How would you plot the average between the 2 sets of data?

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

    Thaaaaaaanks, excellent explanation

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

    Can we add 1 more data to the graph

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

    thanks,helpful video

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

    Thank you this was fucking amazing clear and straight to the point.

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

    Ahhh thank you soo much !!!!!