How To... Create an Overlapping Histogram in Excel
ฝัง
- เผยแพร่เมื่อ 30 ก.ค. 2024
- If you want to plot two histograms on the same diagram, there currently is no option in Excel to do so. However, this can be done using Pivot Tables. In this video you will learn how to plot histograms, using data for heights in males and females, that will overlap each other.
If you would like to learn how to create a Pivot Table, check out my video that will show you how to do this step-by-step:
• How To... Create a Bas...
Saved my day. Thank you. Plus the accent is music to my ears.
This has just saved my presentation with an hour to deadline. Thank you
Out of curiosity, what was your presentation on?
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!
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!
Thank you so much!!! Super easy to follow! I was done in less than 5 minutes!
Straightforward, Clear, and Perfect
this is the best video, you have made my assignment look presentable
This video gave me a thorough understanding of how to work with pivot tables. Saved me on my assignment. Thank you so much.
A really helpful video, thank you!
Such a great instructional video Eugene - many thanks. Just what I needed.
The best video tutorial for overlapping histograms!
Thank you!!
Wonderfully explained. Thank you!
Great and very clear tutorial, thanks!
Great tutorial, thanks!
So much quicker than learning to do it in R! Thanks!
clear and concise, thanks for your help!
Very very good, clear explanantion! Thank you.
So helpful and easy to follow!
This was extremely helpful, thank you!!
Thank you. It is a very useful video.
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.
Out of curiosity, what class was that for, and how did it go?
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 😅
@@beckysmith4913 Oh I totally understand, and I hope your second year is going well!
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.
:-)
That's great to hear! Out of curiosity, how'd the rest of the class go?
Thank you, it helped me a lot
Thank you so much - really helped!
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)
Excellent! Thank you very much!
dear sir, i wish you all the best in the world, this was really helpful. thank you
You're awesome!
Thank you very much, clear and easy to follow
Really helpful. Thanks
Thank you so much you saved me from getting a 0 on my lab!
Thank you. It helped me quite a bit
Thank you. Greetings from South Africa, Geologist
Very clear, a great help, thank you.
This really helped with my wife's Open University TMA. Thanks!
Fingertip Practical? #Same
Excellent!
Wow.. Simply great
You sir are my hero
Thank you so much
Thank you
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?
Out of curiosity, did you find an answer for your question? Also, how did the rest of your class go?
Nice!
Can you teach us how to analyze colocalization and exporting it to excel? Or if you can suggest anyone who can help?
Thanks
Thank you for your videos, how I can comunicate with you (specifically for mail)?
Greetings from Mexico.
Alejandro Gómez, Finnancial analyst.
For some reason, when I try and select a group it will not compute. Is it because I have negative/decimal values?
Is this illustration can be a t test graph also?
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.
Why does excel tell me that I cannot group that data?
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.
how can we insert more than 2 histograms and more than 255cells?