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

แชร์
ฝัง
  • เผยแพร่เมื่อ 12 ก.ย. 2024
  • To get your FREE Tableau Beginner Training course, check out my website at:
    www.udemy.com/...
    -----------------------------------------------
    SUBSCRIBE for new videos Tuesday-Thursday. Click the notification bell so you don't miss a single episode.
    GOT A QUESTION/PROBLEM? Why not request a video using the Comments section below. I'll make a custom video just for you.
    ----------------
    VIDEO DESCRIPTION:
    Working with graphs in Excel can be very fun. However, it never hurts to learn a few tricks along the way. In this video I'll show you how to quickly combine or move one graph into another! A great Excel trick!
    ----------------
    Want to upskill to the next level of Tableau? Consider learning Tableau!
    TRAINING COURSES:
    Udemy - Complete Tableau Training Course
    -Over 184k students and over 13k reviews!
    -200 Lectures and 22 hours of Tableau Content
    www.udemy.com/...
    SkillShare Tableau Training
    www.skillshare...
    ------------------------------------------------------------------
    TH-cam PLAYLISTS:
    Tableau for Beginners - A Quick Start TH-cam Course
    • Tableau for Beginners ...
    Tableau Desktop Accelerator TH-cam Course - A Beginners Guide for New Users
    • Tableau Desktop Accele...
    Tableau Online/Server Short Course - Site Creation, User Management and Licensing
    • Tableau Online/Server ...
    Tableau Online/Server - Complete Playlist
    • Tableau Online/Server ...
    Tableau Desktop - Complete Playlist
    • Tableau Desktop - Comp...
    Tableau Prep - Complete Playlist
    • Tableau Prep - Complet...
    #Tableau
    ------------------------------------------------------------------------------
    RECORDING EQUIPMENT (Amazon Affiliate Program) -
    VIDEO DESCRIBING EACH ( • My Recording Equipment... )
    Headset: Sennheiser GSP 350 - Dolby 7.1 Surround, Noise Canceling, headset volume control
    amzn.to/32N8vpz
    Keyboard 1: Logitech Illuminated K830 Wireless Keyboard with Touchpad
    amzn.to/2IIcHzn
    Keyboard 2: Logitech MX Wireless Illuminated Keyboard
    amzn.to/36BAIk4
    Mouse: Logitech MX Master 2S
    amzn.to/32KMaso (My current model)
    amzn.to/2IF5C2G (Latest Model MX Master 3)
    Laptop Stand: Adjustable/Tilting Laptop Stand Aluminum
    amzn.to/2Uuj7F7
    Monitor: BenQ 1080P 24-Inch Monitor
    amzn.to/2Usen2T
    Webcam: Logitech C920 HD Webcam 1080P
    amzn.to/3kz7Ca3
    LED Studio Lights: x2 Neewar 660 LED Video Lights with Barn Doors, Stand, Bag and Dimmer
    amzn.to/3f3tuJr
    Camera Tripod: Manfrotto Advanced Tripod 3-Way Head with Quick Release
    amzn.to/3pvmg5V

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

  • @pickyphysicsstudent201
    @pickyphysicsstudent201 4 ปีที่แล้ว +31

    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 ปีที่แล้ว +25

    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?

  • @chiarafritzler5500
    @chiarafritzler5500 3 ปีที่แล้ว +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  3 ปีที่แล้ว +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

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

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

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

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

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

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

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

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

      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

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

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

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

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

    SUPER LIKE! YOU SAVED MY ASSIGNMENT

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

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

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

  • @ubaidullah-pj9mu
    @ubaidullah-pj9mu 3 ปีที่แล้ว +2

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

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

    you just saved me so much time. thank you!

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

      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

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

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

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

    You are a life saver.. Thank you

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

    Thank you so much sir!

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

    Super!! Thank you for sharing!

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

      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

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

    WOW! WOW! WOW. Thanks a ton

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

    🤯 likewise, always something new to learn.

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

    Thank you! that is super helpful

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

    Thank you so much for sharing this!

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

    thank you very much!!

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

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

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

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

    YOU SAVED ME THANK YOU 😭🤝🤝

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

    THANK YOU!!

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

    Thank you, you saved me hours

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

    Thank you

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

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

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

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

    Like really duuudeee !!! 😱😱😱😱😱

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

    Thanks a lot

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

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

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

    Sa-ti dea Dumnezeu sanatate.

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

      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

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

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

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

    Could you please show me the pyramid graphs?

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

    Thank you, I got tired trying figure it out

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

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

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

    Back me my two minutes which are wasted watching this

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

    hell that works

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

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

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

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

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

    God bless you😭

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

    cool!

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

      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

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

    Doesn't worl with box plots

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

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

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

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

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

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

    This guy has hacked excel!