Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

Leila Gharani
2.9M subscribers
505K views 4 years ago #excel
Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou... 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. ⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/histogram-c... 🔍 What You'll Learn:  …...more
...more
How To Create A Histogram in Excel (& change the bin size)
4.2KLikes
505,557Views
2020Sep 3
Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou... 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. ⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/histogram-c... 🔍 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.
Link to Excel Basics playlist:    • Excel Introduction - Learn Excel Basics   More Excel charts & data visualization:    • Excel Charts   00:00 When to use a histogram chart 01:16 Excel histogram from scratch 01:32 Change Excel histogram bin size ➡️ Join this channel to get access to perks:    / @leilagharani   👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram:   / lgharani   LinkedIn:   / xelplus   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

Follow along using the transcript.

Leila Gharani

2.9M subscribers