3 Easy Ways to Create a Histogram Chart in Excel

In this video, I will show you three ways to create a histogram chart in Excel.
The following three methods are covered:
-- Using in-built histogram chart option (available in Excel 2016 and later versions)
-- Using Data Analysis Toolpak
-- Using the FREQUENCY function
A histogram is a chart that you can use to see how many times an event occurs in a given range. For example, you can use it to quickly how many students have scored less than 35 and in 35-50 range, or 50-70 range and so on.
This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient
Subscribe to this KZbin channel to get updates on Excel Tips and Excel Tutorials videos - / trumpexcel
This KZbin channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.
It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: trumpexcel.com/
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: kzbin.info...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

[@devoneybrandon5784]

Thank you! This was helpful and clear!

[@sepandjazzi]

Thank you - very clear

[@trumpexcel]

Glad you found the video helpful 🙂

[@skylersilvia8225]

Thanks for the video man, helped with my presentation.

[@nadiyaresham4941]

Thank you so much! This is really helpful.

[@IvanCortinas_ES]

Thank you Sumit. A great video!

[@emilioalvaradogonzalezarag9294]

really helpful, thanks man

[@martin-xq7te]

Great short to the point video. More please

[@033RONNY]

Thank you so much. Very useful

[@emnl8]

This video solved my problem, literally.

[@rashidkhan4455]

Thanks for sharing Dear,

[@dianabaross5229]

Better than my textbook. Thank you!

[@qmsconceptstamil]

Good sir Your teaching is simple and easy understanding

[@efeditz2578]

Nice explanation and it's very helpful for Mee thanks for this video 👍🏻👍🏻

[@peterlever8013]

Great presentation and pace

[@wayneedmondson1065]

Thanks Sumit!

[@gustavonunez2911]

Great video

[@k-panga]

It doesnt give me the option to change the bin with or their numbers, i can select "Bin With", but there is nowhere to specify the with.

[@Knowlejfull]

I can use 3rd method...thank you

[@saurabhgupta5429]

Hi Sumit Sir, I found your video useful in daily office life. Thanks. But how can I use or add xlookup in my existing excel ? Please help.

[@trumpexcel]

Hello Saurabh.. Thanks for commenting and glad you're finding the videos useful! As far as I know, XLOOKUP has not been released for everyone. Only some people have access to it (called the Office Insider program). Even I don't have it yet

[@himkatira]

U make me addicted to excel

[@trumpexcel]

Mission Accomplished ;)

[@taimooriqbal1525]

Array formula can make trouble in my system, kindly give good suggestion

[@Baddaby]

Quick tip for Office 365: Formula arrays don't use anymore the ctrl+shift+enter thing, you just press enter and it's done

[@trumpexcel]

Yeah... this is an old one, but now, with dynamic arrays, no need for CSE

[@shreyasharma7210]

What about when I need to create the chart for two column data??

[@yatinpatel15]

how to use or create a tally mark in histogram chart in excel ?

[@donmontana3538]

how would you add a vertical line to this to show say target value

[@maekiok231]

how do i get the mode when there are gaps?

[@maekiok231]

Ctrl + Shift + Enter deletes the entire frequency column. Does this work on mac?

[@kellohey8624]

i dont get the bin with option up

[@paulashoo]

Options you show in this video for the histogram are not available on Excel on my MacBook...

[@sergejkeser7270]

Hand-drawn histograms it is...