How To... Create an Overlapping Histogram in Excel

Sdílet
Vložit
  • čas přidán 5. 09. 2024

Komentáře • 59

  • @majdmoujahed6899
    @majdmoujahed6899 Před 2 lety +2

    This has just saved my presentation with an hour to deadline. Thank you

    • @PunmasterSTP
      @PunmasterSTP Před 9 měsíci

      Out of curiosity, what was your presentation on?

  • @loue1958
    @loue1958 Před 4 lety +9

    Saved my day. Thank you. Plus the accent is music to my ears.

  • @meysamsojoudi3947
    @meysamsojoudi3947 Před 2 lety +1

    Straightforward, Clear, and Perfect

  • @RosieG1223
    @RosieG1223 Před 4 lety +1

    I spent HOURS trying to figure out how to show two sets of data on one histogram. I ended up creating two line graphs and just overlapping them and deleting all the labels from one so they could look like one graph. I wish I could have found this video last night! Thank you so much for this tutorial! I have deleted the line graphs I created last night and replaced them with the appropriate graph following your instructions. You have saved me major points on my final Measurement Evaluation assignment.

  • @PunmasterSTP
    @PunmasterSTP Před 9 měsíci

    Man, I've created so many histograms over the years for school and work, but I never investigated the different options too deeply. This was such a cool tutorial; thank you for sharing!

  • @paolareyes5625
    @paolareyes5625 Před 10 měsíci

    The best video tutorial for overlapping histograms!
    Thank you!!

  • @magictricks1647
    @magictricks1647 Před 4 lety +5

    this is the best video, you have made my assignment look presentable

  • @mialucio2413
    @mialucio2413 Před rokem

    This video gave me a thorough understanding of how to work with pivot tables. Saved me on my assignment. Thank you so much.

  • @beckysmith4913
    @beckysmith4913 Před rokem +2

    Really appreciated this wonderful tutorial. Id been given some written instructions on how to create an overlapping chart from my tutor as part of our Uni assignment, and I think my laptop would have gone out of the window had I not found your video. Thank you so much for sharing you time and knowledge.

    • @PunmasterSTP
      @PunmasterSTP Před 9 měsíci

      Out of curiosity, what class was that for, and how did it go?

    • @beckysmith4913
      @beckysmith4913 Před 9 měsíci +1

      It was for an Open University assignment in year 1. I forget what it was exactly as I'm so wrapped up in 2nd year now! Haha 😅

    • @PunmasterSTP
      @PunmasterSTP Před 9 měsíci

      @@beckysmith4913 Oh I totally understand, and I hope your second year is going well!

  • @elsitagutierrez1095
    @elsitagutierrez1095 Před 4 lety +4

    Thank you so much!!! Super easy to follow! I was done in less than 5 minutes!

  • @jackieduncan973
    @jackieduncan973 Před 3 měsíci

    Fabulous. I had a problem showing no analysing/grouping selection but I did - add ons - and it seemed to update it so all complete and looking great!

  • @bertieknight812
    @bertieknight812 Před 2 měsíci

    A really helpful video, thank you!

  • @angeldevlin5546
    @angeldevlin5546 Před rokem +1

    You're awesome!

  • @richardandrews9325
    @richardandrews9325 Před 3 lety

    This really helped with my wife's Open University TMA. Thanks!

  • @mohammadqalaji8676
    @mohammadqalaji8676 Před rokem

    Thank you very much, clear and easy to follow

  • @carolefischer2199
    @carolefischer2199 Před 2 lety

    Such a great instructional video Eugene - many thanks. Just what I needed.

  • @seanlightning9634
    @seanlightning9634 Před 6 měsíci

    Thank you so much you saved me from getting a 0 on my lab!

  • @TheDalebob111
    @TheDalebob111 Před rokem

    Really helpful. Thanks

  • @eapawlak
    @eapawlak Před 3 lety

    So much quicker than learning to do it in R! Thanks!

  • @ramkyadi
    @ramkyadi Před rokem

    Wow.. Simply great

  • @jorgenhalolo
    @jorgenhalolo Před 4 lety +1

    Great and very clear tutorial, thanks!

  • @tkeus991
    @tkeus991 Před 2 lety

    dear sir, i wish you all the best in the world, this was really helpful. thank you

  • @scottdiver690
    @scottdiver690 Před 10 měsíci

    Very clear, a great help, thank you.

  • @tflak1
    @tflak1 Před 3 lety

    Very very good, clear explanantion! Thank you.

  • @TheScawer
    @TheScawer Před 7 měsíci

    Great tutorial, thanks!

  • @tommyxu6782
    @tommyxu6782 Před 2 lety

    clear and concise, thanks for your help!

  • @dalelingo1071
    @dalelingo1071 Před 2 lety

    This was extremely helpful, thank you!!

  • @powerfull499
    @powerfull499 Před 4 lety

    Excellent! Thank you very much!

  • @gabrielleliu6785
    @gabrielleliu6785 Před 3 lety

    So helpful and easy to follow!

  • @isabellakarinvanbreda5735

    Thank you. Greetings from South Africa, Geologist

  • @amariitg
    @amariitg Před 3 lety

    Thank you. It helped me quite a bit

  • @rbmy7
    @rbmy7 Před 4 lety

    You sir are my hero

  • @belindaruns
    @belindaruns Před 3 lety

    Thank you so much - really helped!

  • @ka5470
    @ka5470 Před 4 lety +4

    Hello, Dr. Eugene. You helped me so much in the past week with my assignments. I tried to do the histogram the way you taught in past videos. My histogram was right skewed and when I overlap them the bar graphs go on top of each other. Am I doing something wrong? Can I overlapped a right skewed?

    • @PunmasterSTP
      @PunmasterSTP Před 9 měsíci

      Out of curiosity, did you find an answer for your question? Also, how did the rest of your class go?

  • @daniellee2883
    @daniellee2883 Před 3 lety +1

    Very useful video. I was wondering if you could do another video for non disjoint histograms (e.g. display the GDP of European countries vs OECD countries)

  • @mazb33
    @mazb33 Před 5 lety

    Thank you. It is a very useful video.

  • @dhruvsus
    @dhruvsus Před 4 lety

    Thank you so much

  • @blakeywu6692
    @blakeywu6692 Před 4 lety

    Thank you, it helped me a lot

  • @scullyontherocks
    @scullyontherocks Před 5 lety

    Can you teach us how to analyze colocalization and exporting it to excel? Or if you can suggest anyone who can help?

  • @dr.ashuroulet7462
    @dr.ashuroulet7462 Před 5 lety

    Excellent!

  • @muhammadrizalrusdiansyah1998

    Thank you

  • @isabellabarrance9728
    @isabellabarrance9728 Před 3 lety

    For some reason, when I try and select a group it will not compute. Is it because I have negative/decimal values?

  • @nigargojayeva6260
    @nigargojayeva6260 Před 4 lety

    Thanks

  • @mikehuddleston5399
    @mikehuddleston5399 Před 5 lety

    Nice!

  • @alejandrogomez7709
    @alejandrogomez7709 Před 4 lety

    Thank you for your videos, how I can comunicate with you (specifically for mail)?
    Greetings from Mexico.
    Alejandro Gómez, Finnancial analyst.

  • @jaserrano9495
    @jaserrano9495 Před 5 lety

    Is this illustration can be a t test graph also?

    • @EugeneOLoughlin
      @EugeneOLoughlin  Před 5 lety +1

      Hi Jair,
      Yes - you could use this to illustrate the difference between two means (both data sets must be normally distributed).
      You can also use this to show the Effect Size.
      Dr E.

  • @novahalo2461
    @novahalo2461 Před rokem

    Why does excel tell me that I cannot group that data?

    • @novahalo2461
      @novahalo2461 Před rokem

      Figured it out- incase anyone has the same issue, each cell of data I had copy-pasted needed to be changed to 'number' rather than 'general' and altered so that all of the data was set to the same amount of significant figures with any accidental spaces deleted.

  • @Khadra2024
    @Khadra2024 Před 10 měsíci

    how can we insert more than 2 histograms and more than 255cells?

  • @kaff567
    @kaff567 Před 4 lety +1

    Wonderfully explained. Thank you!