How To Create A Histogram in Excel (& change the bin size)

An Excel histogram chart is very easy to make. However it's not always clear when to use a histogram chart or how to adjust it to your needs. Generally, histogram charts are often confused with bar charts. They're very different though. A histogram groups continuous data into ranges, also called bins. The height of each bar shows how many fall into each bin. A histogram is the most commonly used graph to show frequency distributions for data with large value ranges.

In this video I'll show you how you can easily setup a histogram chart in Excel from scratch. We'll also cover how we can customize the bins and format the chart professionally.

🔍 What You'll Learn:
- The purpose and benefits of using histogram charts in Excel.
- Step-by-step process for setting up a histogram chart.
- Customizing bin sizes and ranges for tailored data analysis.

👩‍💼 Perfect for:
- HR professionals looking to analyze salary distributions.
- Excel users interested in data visualization techniques.
- Anyone wanting to understand data spread across various ranges.

📌 Key Highlights:
- Create and customize histogram charts for clear data insights.
- Understand data distributions within specific ranges.
- Make dynamic histograms that update with your data.

00:00 When to use a histogram chart
01:16 Excel histogram from scratch
01:32 Change Excel histogram bin size

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[zilla]

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.

[mcd]

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.

[marilynsmith]

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!

[kyledarrock]

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!

[geirpg]

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.

[joyc]

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!

[hendrikkok]

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!

[MarioBritto]

Thank you Leila, first time i used Histograms, and as always, the explanation is spot on..

[iqbalqr]

Superb work Leila, i was scratching my head for ours with 500+ datasets and you have shown me what to do in 4 minutes

[nonoobott]

Wow...you're such an amazing teacher. I've learned a lot from you. Thanks for sharing

[antebubic-dracari]

Love your work and your will to teach us all this "secrets" that Excel have!

[alyssac]

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.

[darrylmorgan]

Hi Leila!Great Explanation On Histogram Charts..Thank You :)

[TylerStanczak]

This is so helpful. Thanks for going in depth on this Leila. :)

[malwalsabino]

As usual, clear and easy to understand explanation. I give your videos a big credit for my Excel skills

[tatendamutedzi]

Im now your number 1 fan. Officially!
Love from Zimbabwe 🇿🇼

[Holy_Random]

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.

[sambathnarayananparthasara]

In many sites including MS, I couldn't get my question answered, I got answer from your video. Valuable one. Thank you

[nettogrowthpartners]

I bow before you Leila! yours are the best tutorials in YouTube. Many thanks!!

[MichaelGoldner]

Nice and precise explanation. Thank you!