How to Make a Histogram in Excel
In this video I’ll show you how to create a Histogram in excel.
Made with Microsoft Excel for Mac (Version 16.54)
Click a timestamp to jump to any topic below:
What NOT to Do 0:25
Creating Bins 0:52
Sort Data 1:08
Define Bin Range 1:34
Add Analysis Tool Pack 2:30
Data Analysis 2:46
Specify Input Range 2:59
Specify Bin Range 3:10
Select Output Range 3:28
Chart Output 3:46
Resize Histogram 3:56
Delete “More” Bin 4:04
Rename Bins 4:31
Rename X Axis 5:00
Change Gap Width 5:22
Add Column Borders 5:37
Delete the Legend 6:05
Name Your Histogram 6:13