I have found over the years that sometimes the shorter "How to" Excel videos are the ones that stick with me the longest. I appreciate the easy to understand and format of the video well done.
they also have great relookup value. like if I want to find this video again it's super easy to just find a quick short video than it is to remember the long general topic
@@LeilaGharani Hi Mam, I like your videos want your help i have a data and want unique dealers count. negative figures should not be count, ca u pl help me on that so that i can share my data with u
I spent hours trying to help my son create a histogram for an assignment, using the guide provided by the teacher. We were down to this last feature, with no understanding on how to adjust the bin or even what the bin was. Thanks so much for making it so simple!
I've found the histogram function surprisingly limited in terms of features and adjustments in excel, but the overflow and underflow features you have displayed here are very helpful. Thank you!
Thank you so much! I have looked at 6 videos to learn how to create a histogram from my data and your instruction was the clearest explanation of them all. Thanks again!
Another very concise and informative lesson on one of the many chart features of Excel. What I have truly come to appreciate is while you are a well spoken, educated, teacher who understands real world applications of Excel. You are also the kind of woman who enjoys poking a marshmallow with a stick then roasting it over hot coals.
This is the by far best explanation ever of this Excel trick, I went to dozens of sites for an explanation. Yours is by far the best! Congrats and thank you!
This is the best video for me as an Excel beginner...I really like it. It really helped me to answer my excel assignment question...Please add more videos in relation to EXCEL.
It is very important video for me. Not only this video but also all you excle related video are very important for better performance. help of your video my work has been very fast, easy and good. mam if possible please make video regarding "Microsoft access " database. thank you so much for uploading this type video
Thank you soo much for this video!. I've never created one of these and I found out we are going to create this for my class in psychology. You have really made me feel more at ease doing these.
Short and Sweet! I never tried Overflow and Underflow feature, but your video has put me in correct flow to know these! Thanks again for a nice tutorial and looking forward to next Thursday already! (nice attire in this video by the way!) :-)
Thanks Leila, I don't currently use histogram but I think I will add two of them to my August month end reports. The first will be Annual Sales by Customer and the second will be Average Order Size. I will let you know how they look. Thanks for sharing your knowledge. Go Ravens!
I mostly use the histogram chart in Excel to do quick and dirty visualizations of long datasets or when I need to get an intuitive sense of the distribution of a variable in a Monte Carlo simulation. As someone else mentioned, there are formatting issues with the native chart, so if I'm outputting something into a report or what not, I'll go back to a column chart as that allows for more formatting flexibility.
Leila.Good afternoon. I started to follow your excel videos and dashboard. very good teaching. More I would like to ask to enable subtitles in Portuguese
Hi Leila. I’m writing to you for the very first time. I really love your videos. Your style of explanation and bringing examples completely fits my way of understanding. Thank you a lot. Coming back to the topic, I’d like to ask you if you can show how to create a histogram chart that shows how big the values on the vertical axis and what shares of the total amount the values stand for on the horizontal axis. The practical use of it is very convenient when we are talking about marketing data for a set of products in a product line and their sales levels. So I’d like to see what share out of the total product line a certain product has (on the horizontal axis) and what sales level in dollars this product stands for (on the vertical axis). The specific thing is that the width of each column must correspond to its share value.
Hi Leila. Thanks for the video. Very helpful. On a standard chart, if you add a Chart Title, you can link it to a cell on the worksheet. On the Histogram Chart, this seems to not work. You can only type text in manually.. no worksheet link. Seems like a bug. Of course, you can add a Text Box, link it to a cell and then Group the Text Box and Chart together. But, would be nice if the Histogram Chart natively supported Chart Title cell links. Histogram charts are great visualizations. I use them often to show the distribution of tenants with different lease rates in a commercial building.. just one of many uses. Thanks for the Thursday Histogram Chart fun :)) Thumbs up!
Heyah, i opened one assigned Udemy training to me and i saw you are the Instructor great to see you there and enroll in your course in Udemy, more power! :D
Very helpful, I usually work with Power BI desktop, actually most of us use PBI desktop now for visualization. Such a coincidence I got an excel with histogram visuals and was asked to replicate that in to PBI report.
I’m a DJ using histograms to visualize track quantity by beats-per-minute (BPM). It’s useful to spot multiple modes in a large playlist and the BPMs above or below which you’ll have trouble finding another track to mix with (e.g., +/- 4 BPMs usually). Thanks!
This is a great new feature. Thanks for showing. I am confused by bin width though. It would appear that the first bin will always be bigger as it will include the lower and upper value assigned to it. 30k and 110k in your example. The next bin is smaller (very slightly in your case) as it will not include anyone with 30k. My data is with ages of students at a college where the error is more pronounced, as the first bin is 18-21 and the second is 21-24. The first bin includes students who are either 18,19,20,21 and the second bin only three 22,23,24. Thoughts?
Dear Leila, at 3:09 timepoint, if someone has a salary of 70,000, will he be included in the 2nd bin or the 3rd bin? I am asking this because both the bins have the value of 70,000 in them.
Hey Leila, I think I heard you say on another vid that we can make suggestions for future vids in the comments? Could you, if you haven’t, talk to the excel vs other options? What you see as the future of excel (not going anywhere or dying out? I’m not thinking so much about google sheets. More, when I look at productivity stuff, which I’ve used excel for...seems like theirs apps that are meant to be better/easier? Not just project management. I’d use excel for budgets, or customer management, or just personal lists. Nowadays it seems like theirs an app for all these things and more. How do you see excel in that light? And, also the future generally
@@LeilaGharani Scatter with dates on X unless that's improper use of scatter. I'm trying to plot ocean front homes that have sold. Street address as plot labels, price on Y and date on X. You probably know 4 better, and proper, ways to display such data. :)
I'm certainly not expecting you to use my scenario unless it also appeals to the masses without confusion. I'm a horrible teacher. You're an awesome one.
@@charlyRoot I think this is a good topic and can be a specific example of a general enough type that it can be transmogrified into other applications... 😀
I cannot get the bin sizes to round to thousands as shown from 2:11. I followed the exact steps shown in this video but instead of my labels starting from the underflow bin value they still start at the lowest value in my data. What am I doing wrong here?
Great video. I made a histogram. How do I name the bins (the default names (18,28], (28,38], (38,48] etc are horrible. I don't even know what is being shown. But no one shows how to replace these default values with a name for the bin category that is actually meaningful. I want mine to say 18-27 years, 28-37 years, 38-47 years etc. Also there is nothing in my underflow bin but if I remove the underflow bin the bins start from 0 not from 18 where I want them to start from. How do I remove the unused underflow bin from the chart?
Another wonderful video! Thank you, Leila!! I had the same thought. It looks odd - left side round bracket, right side square. Would look cleaner without brackets - on first look, it implies negative numbers.
Hey Leila I have a question about your course. If I take it will it be like taking lessons in college? I.e. learning the basics then it becomes more advanced?
How do you change the data labels though? I'm trying to change the data label, but when I click on one label the whole thing gets selected. And, I can't seem to individually click on one data label. If you're still keeping tabs on your videos, any suggestions? I'd be grateful.
Leila, I would like to know if you can suggest the best formula which would enable you identify counts of full and partial payment for a set of figures in a spreadsheet . Thanks.
Hi Kobe, i think i can help. u need to use a formula in conditional formats that says if any cell in that column of amount is less than certain amount, then it should be coloured in red or whichever colour u choose. your formula would be =$A2
Leila, I use custom views a lot in excel, they save time and memory because you dont need multiple tabs to show each view. That being said, is there a third party tool to allow for multiple selections versus having to check the check box individually ? I sometimes have groups in hundreds of rows I wish to filter, it is time consuming, tedious. I wish Microsoft would address and fix this problem. Can't they make the check boxes multi-selectable like google does with gmail emails ?
Grab the file I used in the video from here 👉 pages.xelplus.com/histogram-chart-file
I have found over the years that sometimes the shorter "How to" Excel videos are the ones that stick with me the longest. I appreciate the easy to understand and format of the video well done.
Great to hear!
they also have great relookup value. like if I want to find this video again it's super easy to just find a quick short video than it is to remember the long general topic
@@LeilaGharani Hi Mam, I like your videos want your help i have a data and want unique dealers count. negative figures should not be count, ca u pl help me on that so that i can share my data with u
I spent hours trying to help my son create a histogram for an assignment, using the guide provided by the teacher. We were down to this last feature, with no understanding on how to adjust the bin or even what the bin was. Thanks so much for making it so simple!
I've found the histogram function surprisingly limited in terms of features and adjustments in excel, but the overflow and underflow features you have displayed here are very helpful. Thank you!
Thank you so much! I have looked at 6 videos to learn how to create a histogram from my data and your instruction was the clearest explanation of them all. Thanks again!
Another very concise and informative lesson on one of the many chart features of Excel.
What I have truly come to appreciate is while you are a well spoken, educated, teacher who understands real world applications of Excel. You are also the kind of woman who enjoys poking a marshmallow with a stick then roasting it over hot coals.
This is the by far best explanation ever of this Excel trick, I went to dozens of sites for an explanation. Yours is by far the best! Congrats and thank you!
I bow before you Leila! yours are the best tutorials in TH-cam. Many thanks!!
Wow, thank you!
In many sites including MS, I couldn't get my question answered, I got answer from your video. Valuable one. Thank you
Glad it was helpful!
This is the best video for me as an Excel beginner...I really like it. It really helped me to answer my excel assignment question...Please add more videos in relation to EXCEL.
Im now your number 1 fan. Officially!
Love from Zimbabwe 🇿🇼
I'm happy to hear that :)
I learned so much from this video. It showed me exactly how to change the bin size and much more than I anticipated. Thank you!
Glad it was helpful!
Superb work Leila, i was scratching my head for ours with 500+ datasets and you have shown me what to do in 4 minutes
very useful. i've been on the struggle making these but this video really helped me understand
Always bringing something new on the table
Trying my best 😊
Thank you so much. Very useful to see the distribution of student grades....
Perfect use for it!
As usual, clear and easy to understand explanation. I give your videos a big credit for my Excel skills
It is very important video for me. Not only this video but also all you excle related video are very important for better performance. help of your video my work has been very fast, easy and good. mam if possible please make video regarding "Microsoft access " database.
thank you so much for uploading this type video
you saved my statistics project, love u
I like your examples, they are very didactic and applied in our working life... from Lima-Peru my best wishes
I'm glad to hear that :)
Wow...you're such an amazing teacher. I've learned a lot from you. Thanks for sharing
It's my pleasure :)
This video seriously saved me. Awesome instruction.
Glad it was helpful, Jemma.
Thank you soo much for this video!. I've never created one of these and I found out we are going to create this for my class in psychology. You have really made me feel more at ease doing these.
Wow...you made it so easy to follow. Please come declutter my life!!
Thank you Leila, first time i used Histograms, and as always, the explanation is spot on..
girl you just saved my life. God Bless!
OmG; never seen such a simple illustration.
Using histogram for my masters statistics course.
Glad you like it.
Short and Sweet! I never tried Overflow and Underflow feature, but your video has put me in correct flow to know these! Thanks again for a nice tutorial and looking forward to next Thursday already! (nice attire in this video by the way!) :-)
Glad you like it, Vijay. Hope it will come in handy for you.
You're such a BOSS! I appreciate the tutorial. But, as always, you drop jems on us to level up our presentation. Thanks!
I appreciate that, Nathan!
Thanks!
Thanks for help, I was able to understand everything very clear. A million of thanks!!:)
This is so helpful. Thanks for going in depth on this Leila. :)
My pleasure. I'm glad it's helpful :)
Thank you so much for this easy explanation!
Superb as always.
Thanks from india !!
Brilliant explanation ❤
Very nice video on Histogram.
You just made my day, thanks! :)
great video. Learnt a lot
I love your videos
Thanks Leila, I don't currently use histogram but I think I will add two of them to my August month end reports. The first will be Annual Sales by Customer and the second will be Average Order Size. I will let you know how they look. Thanks for sharing your knowledge. Go Ravens!
Great histogram explanation. Currently taking your excel dashboard course, it is great too. Thanks for making this available!
Awesome, thank you Mark!
I mostly use the histogram chart in Excel to do quick and dirty visualizations of long datasets or when I need to get an intuitive sense of the distribution of a variable in a Monte Carlo simulation. As someone else mentioned, there are formatting issues with the native chart, so if I'm outputting something into a report or what not, I'll go back to a column chart as that allows for more formatting flexibility.
Thanks for sharing your experience, Jonathan!
This just saved me 7 hours of trial and error😂 💪
Hi Leila!Great Explanation On Histogram Charts..Thank You :)
U are the best and most pleasant to listen too.
Short, but very informative video
Excellent explanation Leila. Thank you for sharing with us this graphic!!
You're very welcome, Iván!
Simple and great explanation. V. Good
Nice and easy on the brain power today :)
Leila.Good afternoon. I started to follow your excel videos and dashboard. very good teaching. More I would like to ask to enable subtitles in Portuguese
Hi Leila. I’m writing to you for the very first time. I really love your videos. Your style of explanation and bringing examples completely fits my way of understanding. Thank you a lot. Coming back to the topic, I’d like to ask you if you can show how to create a histogram chart that shows how big the values on the vertical axis and what shares of the total amount the values stand for on the horizontal axis. The practical use of it is very convenient when we are talking about marketing data for a set of products in a product line and their sales levels. So I’d like to see what share out of the total product line a certain product has (on the horizontal axis) and what sales level in dollars this product stands for (on the vertical axis). The specific thing is that the width of each column must correspond to its share value.
Nice and precise explanation. Thank you!
Hi Leila. Thanks for the video. Very helpful. On a standard chart, if you add a Chart Title, you can link it to a cell on the worksheet. On the Histogram Chart, this seems to not work. You can only type text in manually.. no worksheet link. Seems like a bug. Of course, you can add a Text Box, link it to a cell and then Group the Text Box and Chart together. But, would be nice if the Histogram Chart natively supported Chart Title cell links. Histogram charts are great visualizations. I use them often to show the distribution of tenants with different lease rates in a commercial building.. just one of many uses. Thanks for the Thursday Histogram Chart fun :)) Thumbs up!
Very informative. Thank you
Heyah, i opened one assigned Udemy training to me and i saw you are the Instructor great to see you there and enroll in your course in Udemy, more power! :D
Always useful amazing video and i learn from it to more better knowledge when i’m using excel. Thank you so much 🙏🏻
My pleasure :)
Thank you so much!😀
Leila Gharani always excelled in excel and dress
😁
very short and informative
I like the Salsa in the background. Do you dance it? 🎺🎵🌿
The core purpose... well, whether it's simpler or harder, you always rock it.
Oh, so that is Salsa? Sorry, not a dancer 😁
This is so helpful!!! This example applies to my job 100% and now I have all these ideas now.
Happy to help, George :)
Exceptional Fam!
I don’t use it currently but I will moving forward as the data I work with can definitely work for this.
That's great, Ashley. Let us know how it went.
That intro music is pretty lit
Nice video Leila
Love your work and your will to teach us all this "secrets" that Excel have!
Great video as always, but for this one I love the soundtrack
Me too 💃😁
Very helpful, I usually work with Power BI desktop, actually most of us use PBI desktop now for visualization.
Such a coincidence I got an excel with histogram visuals and was asked to replicate that in to PBI report.
Спасибо большое, Лейла!
I’m a DJ using histograms to visualize track quantity by beats-per-minute (BPM). It’s useful to spot multiple modes in a large playlist and the BPMs above or below which you’ll have trouble finding another track to mix with (e.g., +/- 4 BPMs usually). Thanks!
Nice concept. Can you please do this mac users? Thank you
This is a great new feature. Thanks for showing. I am confused by bin width though. It would appear that the first bin will always be bigger as it will include the lower and upper value assigned to it. 30k and 110k in your example. The next bin is smaller (very slightly in your case) as it will not include anyone with 30k. My data is with ages of students at a college where the error is more pronounced, as the first bin is 18-21 and the second is 21-24. The first bin includes students who are either 18,19,20,21 and the second bin only three 22,23,24. Thoughts?
THANK YOU SO MUCH
Hi Leila! Is there a way to add dashes between the upper limit and lower limit numbers in each bin like 10-20, 20-30, 30-40 and so on?
That's great. I was defining the CI earlier to group manually
thanks again leila
Dear Leila, at 3:09 timepoint, if someone has a salary of 70,000, will he be included in the 2nd bin or the 3rd bin? I am asking this because both the bins have the value of 70,000 in them.
Thanks Leila, please why some people uses frequency in Y axis? what this does mean?
I used histogram for account balances in different account.
Thank 👍
Thanks, more about charts plz.
Hey Leila, I think I heard you say on another vid that we can make suggestions for future vids in the comments?
Could you, if you haven’t, talk to the excel vs other options?
What you see as the future of excel (not going anywhere or dying out?
I’m not thinking so much about google sheets. More, when I look at productivity stuff, which I’ve used excel for...seems like theirs apps that are meant to be better/easier?
Not just project management. I’d use excel for budgets, or customer management, or just personal lists. Nowadays it seems like theirs an app for all these things and more.
How do you see excel in that light?
And, also the future generally
Ugh. I love your videos so much I get upset when I need something in Excel and you don't have one on that topic.
No scattergraph videos. :(
Just added to my list 😊
@@LeilaGharani Scatter with dates on X unless that's improper use of scatter. I'm trying to plot ocean front homes that have sold. Street address as plot labels, price on Y and date on X.
You probably know 4 better, and proper, ways to display such data. :)
I'm certainly not expecting you to use my scenario unless it also appeals to the masses without confusion. I'm a horrible teacher. You're an awesome one.
@@charlyRoot I think this is a good topic and can be a specific example of a general enough type that it can be transmogrified into other applications... 😀
@@michaellucas7177 I'm gonna have to Google "transmogrified" but I... think I agree...
I'll circle back on that post transgooglefication.
Great! Can I add normal curve on histogram in excel automatically?
I cannot get the bin sizes to round to thousands as shown from 2:11. I followed the exact steps shown in this video but instead of my labels starting from the underflow bin value they still start at the lowest value in my data. What am I doing wrong here?
Hey Leila - is there an easy way to make a log scale on the histo ...
How do we create histogram with variable width for classes with varying widhts?
when I click on the horizontal access of the graph those bin options do not appear
Same here. Would really appraciate som input on how to get the bin options!
@@Seraphic75 copy and paste to stat crunch, haha
Great video. I made a histogram. How do I name the bins (the default names (18,28], (28,38], (38,48] etc are horrible. I don't even know what is being shown. But no one shows how to replace these default values with a name for the bin category that is actually meaningful. I want mine to say 18-27 years, 28-37 years, 38-47 years etc. Also there is nothing in my underflow bin but if I remove the underflow bin the bins start from 0 not from 18 where I want them to start from. How do I remove the unused underflow bin from the chart?
Thank you!
Great video! Is there a way to remove the square brackets in the x axis of the chart? For example change the [30,000, 70,000] to 30,000 - 70,000?
Another wonderful video! Thank you, Leila!! I had the same thought. It looks odd - left side round bracket, right side square. Would look cleaner without brackets - on first look, it implies negative numbers.
Thanks for sharing.
How to add smooth curve in histogram.
Hey Leila I have a question about your course. If I take it will it be like taking lessons in college? I.e. learning the basics then it becomes more advanced?
Not sure which course you mean but generally the curriculum is structured and the lectures build on each other.
very useful lesson , do you know channels on TH-cam explaining Microsoft word programme
Is there a way to change the commas to dashes for the salary ranges?
How do you change the data labels though? I'm trying to change the data label, but when I click on one label the whole thing gets selected. And, I can't seem to individually click on one data label. If you're still keeping tabs on your videos, any suggestions? I'd be grateful.
Leila,
I would like to know if you can suggest the best formula which would enable you identify counts of full and partial payment for a set of figures in a spreadsheet . Thanks.
Hi Kobe, i think i can help. u need to use a formula in conditional formats that says if any cell in that column of amount is less than certain amount, then it should be coloured in red or whichever colour u choose. your formula would be =$A2
Thank you
Can we create histogram for manhours worked for different projects
Leila,
I use custom views a lot in excel, they save time and memory because you dont need multiple tabs to show each view. That being said, is there a third party tool to allow for multiple selections versus having to check the check box individually ? I sometimes have groups in hundreds of rows I wish to filter, it is time consuming, tedious. I wish Microsoft would address and fix this problem.
Can't they make the check boxes multi-selectable like google does with gmail emails ?