Grab the file I used in the video from here 👉 pages.xelplus.com/histogram-chart-file
@ProjectPhysX
3 жыл бұрын
There is no field to enter a number next to "Bin width". Why is Excel such a garbage software?
@zilla3745
4 жыл бұрын
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.
@LeilaGharani
4 жыл бұрын
Great to hear!
@SuperWolfkin
4 жыл бұрын
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
@pramodbhatt6906
4 жыл бұрын
@@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
@kyledarrock
2 жыл бұрын
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!
@mcd22630
4 жыл бұрын
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.
@nonoobott8602
4 жыл бұрын
Wow...you're such an amazing teacher. I've learned a lot from you. Thanks for sharing
@LeilaGharani
4 жыл бұрын
It's my pleasure :)
@TylerStanczak
4 жыл бұрын
This is so helpful. Thanks for going in depth on this Leila. :)
@LeilaGharani
4 жыл бұрын
My pleasure. I'm glad it's helpful :)
@aaryakotibhaskar7177
4 жыл бұрын
How do we create histogram with variable width for classes with varying widhts?
@XcelGuruSayantan
4 жыл бұрын
I used histogram for account balances in different account.
@geirpg
4 жыл бұрын
I've watched a few of your videos. I just want to say thank you for presenting the subject in such an easy to understand way. It only took watching two of your videos to have my boss and colleagues looking to me as the local "excel guru". Now I'll have to watch the rest of your videos to keep that title.
@wayneedmondson1065
4 жыл бұрын
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!
@orthopaedicmd
4 жыл бұрын
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.
@LeilaGharani
4 жыл бұрын
Thanks for sharing your experience, Jonathan!
@stevew4079
4 жыл бұрын
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
@marilynsmith2749
Жыл бұрын
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!
@mzr0
4 жыл бұрын
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?
@jayholm8976
4 жыл бұрын
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.
@Holy_Random
4 жыл бұрын
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.
@darrylmorgan
4 жыл бұрын
Hi Leila!Great Explanation On Histogram Charts..Thank You :)
@AusFastLife
Жыл бұрын
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?
@harshpatel-fn1db
4 жыл бұрын
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
@prathvisingh8288
3 жыл бұрын
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.
@scottmacphee8563
3 жыл бұрын
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?
@Cyb3rP0p3
4 жыл бұрын
Poor Paul, didn't have to demote him! He wanted to go part time anyway. =)
@LeilaGharani
4 жыл бұрын
True, that would have been a nicer way to put it 😊
@virammodhavadiya6348
4 жыл бұрын
In my excel direct histogram graphs are not available in insert menu ???
@listerdave1240
4 жыл бұрын
Same here. I had to activate a plugin or something and still it doesn't appear in that menu bar. Maybe I have older version of Excel.
@abijahmaniaco
2 жыл бұрын
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!
@dww527
4 жыл бұрын
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 ?
@tatendamutedzi1753
4 жыл бұрын
Im now your number 1 fan. Officially! Love from Zimbabwe 🇿🇼
@LeilaGharani
4 жыл бұрын
I'm happy to hear that :)
@ludovicboully3643
4 жыл бұрын
Thank you so much. Very useful to see the distribution of student grades....
@LeilaGharani
4 жыл бұрын
Perfect use for it!
@DenHenson
3 жыл бұрын
when I click on the horizontal access of the graph those bin options do not appear
@Seraphic75
3 жыл бұрын
Same here. Would really appraciate som input on how to get the bin options!
@DenHenson
3 жыл бұрын
@@Seraphic75 copy and paste to stat crunch, haha
@Grumpy_Granddad
4 жыл бұрын
Nice and easy on the brain power today :)
@Crimson_and_Clover_
2 ай бұрын
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.
@nishaahujajbj5921
4 жыл бұрын
U are superb...i am ACCOUNTANCY teacher i want support from u if possible..#cbseaccountancy,eco by nisha ahuja
@michaelbujaki2462
8 ай бұрын
This is why I HATE Microsoft. This video is three years old and it's already out of date and completely useless for the version I have (Office 365).
@lucastsigarides8411
2 жыл бұрын
Hi can anyone help? I have my histogram set up but my ranges go for example, 70-74, 74-78, 78-82 but I want the second bar to start at 75-78 and then 79-82 and so on. How do i edit my histogram to allow this? Thanks.
@dharmendarrana4191
4 жыл бұрын
Hii Ma'am, My Name is Rupesh. I'm from maharastra India. I want to know.... The total time ( 07:59:59 ) the employee works in a company is 1 month . It called MTD. How to covert hour minute and second into total hours without decimal in number by the excel formula ?....
@prathvisingh8288
6 ай бұрын
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?
@vijayarjunwadkar
4 жыл бұрын
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!) :-)
@LeilaGharani
4 жыл бұрын
Glad you like it, Vijay. Hope it will come in handy for you.
@rudylopez692
2 жыл бұрын
What happened to the dates? I didn't see them in the graph. They are written differently than mine. My dates come out as "21-May" for Example when I put May 21.
@andreahurt8268
Ай бұрын
She went way too fast, when trying to follow. In the future slow it down, your explanations are great, just way too fast for beginner users.
@afmkamrulhassan7003
3 жыл бұрын
There seems to be an error in this video. The upper limit value of a bin and the lower limit value of the next bin are the same. If my salary is, say 30,000, what will be my location? In the first bar or in the second bar? Thank you.
@rudylopez692
2 жыл бұрын
I like short videos but for someone like me who is new to Excel, it was too fast for me. Too many clicks in too short of time. yes, I know I can pause it and go back and pause it and go back but a little slower please or make videos for new people separately, I just started learning excel yesterday.
@narekaghekyan2707
2 жыл бұрын
Can we make data labels as percentages? Like 5% gets
@ruhanvanhuyssteen6665
Жыл бұрын
Is there a way to display the range with a dash (-) instead of a comma (,) on the x-axis. For example 20 000-30 000
@GoodEarthSpa
Жыл бұрын
What is the cat's favorite chart? A Hisssstogram.
@LeilaGharani
Жыл бұрын
😂
@osamamanan2723
2 ай бұрын
The other versions of excel can make things confusing. There is no bin option in my version and I lost my mind
@mahamanoumar1802
3 жыл бұрын
Thanks Leila, please why some people uses frequency in Y axis? what this does mean?
@abdallah.kandiel
4 жыл бұрын
First comment
@jpatra1000
4 жыл бұрын
I use histogram most of the time to do error analysis
@sunnybaggu785
2 жыл бұрын
Hii...Can we draw a tetrahedron with known 3d (x,y,z) coordinates in excel chart
@Larwai
2 жыл бұрын
Hello: How if we create the Bin with frequency from Data Analysis in Excel?
@angusho9329
Жыл бұрын
The bin adjustment feature does not exist in Excel for Mac...
@jnhnmk
3 жыл бұрын
Can you help how to compere program language evolution using excel chart please
@bettys7298
3 жыл бұрын
what if after the 'ctrl + 1' the 'axis options' is not showing up??? tks!!!
@mohammadkalandar1440
2 жыл бұрын
Can we create histogram for manhours worked for different projects
@ayushroy3514
2 жыл бұрын
I don't get the same options when I press control + 1. Someone please help
@isaiahogujiuba5511
2 жыл бұрын
Nice concept. Can you please do this mac users? Thank you
@anonymous.content.
2 жыл бұрын
Is there a way to change the commas to dashes for the salary ranges?
@mertkeles5617
Жыл бұрын
what if i wanna make [110.000 , 150.000] not (110.000 , 150.000]
@antillmatthew
2 жыл бұрын
Hey Leila - is there an easy way to make a log scale on the histo ...
@ProgramadorExcelVBA
4 жыл бұрын
Thank 👍
@mariostudio7
4 жыл бұрын
A few months ago, I needed to make a surface chart but the bin width shouldn't be equal for the ranges I needed it for. ☹️ For example: 200.
@learningwithmaliha
5 ай бұрын
Very nice video on Histogram.
@zabiullahMONTAGES
4 жыл бұрын
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?
@LeilaGharani
4 жыл бұрын
Not sure which course you mean but generally the curriculum is structured and the lectures build on each other.
@dicksonhaulai6815
2 жыл бұрын
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.
@shivananda4102
4 жыл бұрын
I am looking for help I have excel with columns id, submit date ,close date I need chart x axis with date, y axis count of submitted ids and closed ids. Is there anyway to get view without creating separate table? And formulas to get count
@Anonom2012
3 жыл бұрын
What if you don't have 2016 and have created a histogram from a pivot table, ie, pivot column chart? I can group the categories by values, but they need to be consistent. Is there a way of creating an overflow bin?
@cshahed
4 жыл бұрын
Always bringing something new on the table
@LeilaGharani
4 жыл бұрын
Trying my best 😊
@monsieurlepenguin6602
3 жыл бұрын
there's no bin width when I do ctrl+1
@georgedoolittle7574
4 жыл бұрын
"Skew" or "how we can be fooled by Data." Statistical theory presents "numbers" always in an even distribution but as you show here this is never the case. According to ahem "statistical theorists" ahem the "skew" will always be normalized also known as "reversion to the mean" or "a mean distribution" but of course in actuality this is not only never the case but as you rightly show here can never be the case. Some deal in millions, some deal in billions but in point of fact a few will be dealing in trillions now. This is now known as the "New Normal" or the problem of skew in the use of all things data driven or "statistical."
@mattschoular8844
4 жыл бұрын
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!
@ronaldofernandesdesouza5752
4 жыл бұрын
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
@perezbernia7516
2 жыл бұрын
Thanks for help, I was able to understand everything very clear. A million of thanks!!:)
@rezkelsayed2689
4 жыл бұрын
very useful lesson , do you know channels on KZitem explaining Microsoft word programme
@sharadmohip6536
3 жыл бұрын
i cannot find this on office 365 FML
@barttitulaerexcelbart9400
4 жыл бұрын
Hello Leila, thanks for the video as always: well explained. But.... I do have some doubt about the statistic value of a Histogram made by Microsoft. The Histogram functionality a long time available in the "Data Analysis tool" (Add inn) was not correct since the bars were be not connected (not continuous) . This is solved in the new Histogram diagrams lately introduced. But according to the statistic rules, the bin seizes should be the same. This is not the case in the 190K-200K but they are visualized with the same with. If you do have to make unequal bin sizes you have to adapt the absolute frequency to a relative frequency, then the SURFACE of a bar reflects the relative share. en.wikipedia.org/wiki/Histogram . Another issue: if you have discrete values, to which class does the value at the border belong, the right or the left? In Excel (also in the Frequency formula) the rule is : left border of the bin < x right border of the bin. Is this also correct?
@analyzeweekly
4 жыл бұрын
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.
@hendrikkok5843
3 жыл бұрын
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!
@malwalsabino519
Жыл бұрын
As usual, clear and easy to understand explanation. I give your videos a big credit for my Excel skills
@paolatorres849
Жыл бұрын
very useful. i've been on the struggle making these but this video really helped me understand
@joyc3111
2 жыл бұрын
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!
@mousnor
3 жыл бұрын
I'm having a problem, when I want to change get bind size I can select the option, but there is no box to type the desired number in.
@jpete190
4 жыл бұрын
Leila, why a histogram chart and not a normal bar chart, Is it just preference?
@-k-tower8929
3 жыл бұрын
Bar chart is used for nominal and ordinal data types. But salary is interval, and for that data type we use histograms
@genesiss7359
3 жыл бұрын
I am using Excel because I have a 20-page statistics project : (
@funnyclips2696
2 жыл бұрын
Great! Can I add normal curve on histogram in excel automatically?
@binsoyaviles1786
4 жыл бұрын
Hi! i badly need help in my multiple cell IF statement problem. Hope you can help me. Wont take too long.
@totumeducacao
4 жыл бұрын
I love your videos
@creative_gujarati
4 жыл бұрын
Superb as always. Thanks from india !!
@selinkids6617
Жыл бұрын
That intro music is pretty lit
@keithmelvin258
3 жыл бұрын
Wow...you made it so easy to follow. Please come declutter my life!!
@kamlesh.hariyani
4 жыл бұрын
Waiting for your videos on Pareto chart Box plot chart
@katelyngant5007
3 жыл бұрын
How do you make the bin width represent a value rather than being a range?
@alyssac240
2 жыл бұрын
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.
@kamlesh.hariyani
4 жыл бұрын
Thanks for sharing. How to add smooth curve in histogram.
@phoenixblack1220
Жыл бұрын
Thank you so much for this easy explanation!
@iqbalqr
3 жыл бұрын
Superb work Leila, i was scratching my head for ours with 500+ datasets and you have shown me what to do in 4 minutes
@newvemo
4 жыл бұрын
How to remove blank rows using formula in excel?
@desmondchiemezieugwuanyi8197
Жыл бұрын
This just saved me 7 hours of trial and error😂 💪
@dheerajsachdeva8828
3 жыл бұрын
Hi, I don't have a bin width option in my mac (in excel 2019) in the format axis, your support will be very much appreciated. Thanks
@LeilaGharani
3 жыл бұрын
Unfortunately, not every feature from the Windows version makes it into Excel for Mac.
@dheerajsachdeva8828
3 жыл бұрын
@@LeilaGharani ohh that's sad, it's quite handy one. Thanks btw for the video.
@JamesReyesjadsr
4 жыл бұрын
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
@MarioBritto76
4 жыл бұрын
Thank you Leila, first time i used Histograms, and as always, the explanation is spot on..
Пікірлер: 208