A histogram (also called a frequency distribution chart) shows how many times a specific value occurs within a certain range. It is super-useful if you want to know how a variable is statistically distributed. But Excel’s built-in histogram tool is not the best tool to use:
- It requires you to specific “bin values” before hand, which requires you to know the minimum and maximum values;
- If you want to change the number of bars, you have to manually change bar values.
- The bins are not labeled correctly.
Here we introduce a better way – using PivotTable. See the below: