Histogram Charts in Excel
In this video, you'll discover two different methods to create a Histogram Chart in Excel, firstly by using the standard chart tools and secondly by using the Data Analysis Toolpak.
TIME CODES (click the link to go directly to that spot in the video)
(0:10) Three examples of what a Histogram Chart in Excel looks like
(0:21) How to read/interpret a Histogram Chart
(0:41) The subtle differences between Histograms created using the chart tool and this created using the Data Analysis tool
(0:58) Method 1: How to create a Histogram Chart in Excel using the standard chart tool
(1:43) Two ways to improve the way numerical bins are displayed (changing the bin width and changing the number of numerical bins)
(2:51) How to utilise the Overflow Bin and Underflow Bin
(3:31) How to change the gap width
(3:56) Method 2: How to create a Histogram Chart in Excel using the Data Analysis tool
(4:10) Where to find the Data Analysis tool
(4:40) How to set up your Frequency Distribution data
(6:22) How to modify the Frequency Distribution labels
(7:49) How to close the gap on the Histogram
(8:31) Eliminating zero frequencies (empty numerical buckets)
(8:47) Another example using a different frequency distribution
(10:22) Don't forget to try the Chart Styles and Quick Layouts!
😃 If you found this video useful, don't forget to give a thumbs up.
😃 What ONE thing resonated with you the most? Let me know by adding a quick COMMENT or question below.
Go get ‘em.
USEFUL LINKS:
Share this Video:
• Histogram Charts in Excel
My 30 Best Excel Power Tips
https://officemastery.com/lm/30-excel...
😃 SUBSCRIBE if you want to see more content like this
https://www.youtube.com/c/JasonMorrel...
😃 HIRE JASON to fix your broken spreadsheets or to get private 1-on-1 Zoom coaching
https://trst.com.au/microsoft-trouble...
😃 ABOUT THE PRESENTER:
Jason Morrell helps people of all levels to leverage the power of Microsoft Office. Delivering training since 2002, he loves to simplify the hard stuff and provide helpful, actionable advice that has been proven to slash hours from daily computer tasks. Jason lives with his wife and 4 kids on the beautiful Gold Coast in Queensland, Australia.
😃 LET'S CONNECT!
https://officemastery.com (free training on the blog)
/ officemastery
/ jkmorrell
/ jasonmorrell
Have a fantastic day!