MS Excel - Combining Two Graphs Into One! Cool Trick!

Поділитися
Вставка
  • Опубліковано 26 січ 2025

КОМЕНТАРІ • 70

  • @pickyphysicsstudent201
    @pickyphysicsstudent201 4 роки тому +30

    You saved me like 180 minutes of work and tinkering, thank you!

  • @iatsak167
    @iatsak167 4 роки тому +10

    I was searching for something like this through many useless youtube videos, this is so easy and amazing, thanks!

  • @broderp
    @broderp 4 роки тому +26

    Only works if data is the same type. (numbers in this case) How do you combine two graphs if one data set is a general number and the other is a percentage? Doing this method just gives a flat line at the bottom representing percentages. How do you do that?

  • @possiblyletty
    @possiblyletty 3 роки тому +1

    I've just spent a whole 2 hours tinkering with this - you're a legend - thank you!

  • @matthijsvandam7411
    @matthijsvandam7411 3 роки тому +1

    You are the hero of my Master thesis thank you so much

  • @aditigurung4713
    @aditigurung4713 Рік тому

    YOU SAVED ME THANK YOU 😭🤝🤝

  • @jeanettesefers8180
    @jeanettesefers8180 Рік тому

    That was so cool and easy.. Thanks for sharing.

  • @DanBurgaud
    @DanBurgaud Рік тому

    0:50 I have a very big (13000 lines) data; selecting this way isnt practical for me. Any way of selecting it?

  • @ubaidullah-pj9mu
    @ubaidullah-pj9mu 3 роки тому +2

    the longest copy paste tutorial i've seen lmao!!
    much appreciated tho!

  • @chiarafritzler5500
    @chiarafritzler5500 4 роки тому +5

    OH MY GOODNESS WHERE HAVE YOU BEEN. Thank you so much, I have been spending so much unnecessary time doing it with the "add data" function!

    • @jellymaneducation6168
      @jellymaneducation6168  4 роки тому +1

      Hahahahaha you just described my whole tableau experience lols. Personally after all these years I still pick up a few tricks from time to time

  • @kal-el3644
    @kal-el3644 3 роки тому +3

    Thank you so much for sharing this man. I was literally just about to leave the project in frustration, due to the time-consuming process of data selection. Just at the right time!

    • @jellymaneducation6168
      @jellymaneducation6168  3 роки тому

      Thats awesome. Whats the project?

    • @kal-el3644
      @kal-el3644 3 роки тому +2

      @@jellymaneducation6168 I’m doing an important presentation for my college and I needed to somehow combine data and therefore make one graph out of 6 different graphs. It ended up great and thanks to your video I didn’t have to waste much time on the matter:)

  • @namHin22815
    @namHin22815 Рік тому

    WOW! WOW! WOW. Thanks a ton

  • @RobertCone
    @RobertCone 3 роки тому +1

    Subscribed just because of this video, let's see what other tricks there are that two hours of googling doesn't bring up that maybe you will!

  • @abynit
    @abynit 4 роки тому +2

    How to do this if x-axis of second plot is also different.

  • @harati6744
    @harati6744 3 роки тому +1

    Super!! Thank you for sharing!

    • @jellymaneducation6168
      @jellymaneducation6168  3 роки тому

      Hi, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy.
      jellyman-education.thinkific.com/courses/getting-started-with-tableau

  • @marcandre6740
    @marcandre6740 9 місяців тому

    SUPER LIKE! YOU SAVED MY ASSIGNMENT

  • @fun_timez_uk
    @fun_timez_uk 3 роки тому +2

    Brilliant thanks! That was so easy I’m glad we saw this !

    • @jellymaneducation6168
      @jellymaneducation6168  3 роки тому

      Hi Fun Timez UK, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy.
      jellyman-education.thinkific.com/courses/getting-started-with-tableau

  • @dcariello15
    @dcariello15 3 роки тому +2

    Great video! But I have a question: how do you add the two Y-axis on both the left and right AND also add the y-axis labels?

  • @PURNAMILIND
    @PURNAMILIND 2 роки тому +1

    You are a life saver.. Thank you

  • @zaidized2912
    @zaidized2912 4 роки тому +1

    Thank you so much sir!

  • @sureshimmadi8236
    @sureshimmadi8236 Рік тому

    What is one column of values are in number format and values in another column are in percentage format?? Please reply. Thanks

  • @pagej4
    @pagej4 3 роки тому +1

    you just saved me so much time. thank you!

    • @jellymaneducation6168
      @jellymaneducation6168  3 роки тому

      Hi Jeremy, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy.
      jellyman-education.thinkific.com/courses/getting-started-with-tableau

  • @ghostfreak9137
    @ghostfreak9137 2 роки тому +1

    Thanks for this video it helped me prepare superimposed graph for the master curriculum 🙂

  • @fredwooten14
    @fredwooten14 2 роки тому +1

    Udemy & youtube fantastic!!

    • @jellymaneducation6168
      @jellymaneducation6168  2 роки тому

      Thanks Freddie! Btw, I have a FREE Tableau course now available on my website if you're interested!
      jellyman-education.thinkific.com/courses/getting-started-with-tableau

  • @edric9911
    @edric9911 3 роки тому +1

    thank you very much!!

  • @zackvizeman5329
    @zackvizeman5329 4 роки тому +1

    Outstanding trick; your friend and you are generous! Thanks very much!

  • @Rodriguito123456
    @Rodriguito123456 4 роки тому +1

    I tried this with two boxplot graphs in excel 2013 and the values of the pasted boxplot where modified in the final graph. How can I correct this?

  • @mythilisamyuktha8898
    @mythilisamyuktha8898 Рік тому

    Could you please show me the pyramid graphs?

  • @mariabdugarte7175
    @mariabdugarte7175 4 роки тому +1

    Thank you! that is super helpful

  • @fotomakr
    @fotomakr Рік тому

    🤯 likewise, always something new to learn.

  • @alvinyang5048
    @alvinyang5048 3 роки тому

    Thank you so much for sharing this!

  • @camlocarter5842
    @camlocarter5842 2 роки тому

    Thank you, you saved me hours

  • @glob567
    @glob567 4 роки тому +1

    Thank you

  • @GauravKumawat26
    @GauravKumawat26 2 роки тому

    Like really duuudeee !!! 😱😱😱😱😱

  • @agwujerome6084
    @agwujerome6084 2 роки тому

    God bless you😭

  • @monyetguru
    @monyetguru 3 роки тому +1

    THANK YOU!!

  • @alansari1985
    @alansari1985 Рік тому

    Doesn't worl with box plots

  • @adhip0574
    @adhip0574 Рік тому

    HOW DO YOU GIVE THEM DIFFERENT AXIS!!!!!!!

  • @aaryanbudhiraja1656
    @aaryanbudhiraja1656 4 роки тому +1

    Thanks a lot

  • @jasondmaguire
    @jasondmaguire 9 місяців тому

    I cant seem to get this to work. Im trying to over lay consultations per month with revenue per month. no matter what it always shows back up with one line. please help!!!!

  • @martina71704
    @martina71704 3 роки тому

    Hi, I couldn't make it work for two bar graphs!

  • @dinosaurtimesten
    @dinosaurtimesten 3 роки тому +1

    Damn bro, if only I had known this in college.

  • @_dMb_dMb
    @_dMb_dMb 2 роки тому +1

    hell that works

  • @WhatsNextt
    @WhatsNextt 3 місяці тому

    why it doesnt work for me

  • @marians8048
    @marians8048 3 роки тому +2

    Sa-ti dea Dumnezeu sanatate.

    • @jellymaneducation6168
      @jellymaneducation6168  3 роки тому

      Hi Marian, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy.
      jellyman-education.thinkific.com/courses/getting-started-with-tableau

  • @hamadhassan480
    @hamadhassan480 2 роки тому +3

    Back me my two minutes which are wasted watching this

  • @mjs1592
    @mjs1592 4 роки тому

    Thank you, I got tired trying figure it out

  • @erfanzandi1338
    @erfanzandi1338 3 роки тому +1

    cool!

    • @jellymaneducation6168
      @jellymaneducation6168  3 роки тому

      Hi Erfan, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy.
      jellyman-education.thinkific.com/courses/getting-started-with-tableau

  • @truth517
    @truth517 4 роки тому +1

    Doesn’t work on mines

  • @Tommuli_Haudankaivaja
    @Tommuli_Haudankaivaja Рік тому

    Unfortunatelly, it would seem that doing this crashes my Excel. I'll just have to tell my boss that no can do. 5 million data points are too much.

  • @bahaablast5525
    @bahaablast5525 2 роки тому

    -40% for not including Legends and not showing me how to transfer over legends

  • @GeckoForReal
    @GeckoForReal 3 роки тому

    Thanks, but you could have just skipped the first 1 min 30 s of the video. Because how to create a graph is not the topic :).

  • @shivaputra_krishna_IIT
    @shivaputra_krishna_IIT 2 роки тому

    This guy has hacked excel!