Histogram Charts are one of the many new Charts available only in Excel 2016.
They are very visual as it can easily show you the distribution of numerical data, like seeing which numerical ranges are the most common.
In this example I show you how easy it is to insert a Histogram Chart using Excel 2016.
To upgrade to Excel 2016 you can use this link here: Microsoft Office 2016
STEP 1: Highlight your column with numerical data and go to Insert > Recommended Charts
STEP 2: Select All Charts > Histogram > OK
STEP 3: Now you have your Histogram Chart.
STEP 4: You can further change the way how your Histogram Chart represents your data, by double-clicking on the horizontal axis containing our values.
STEP 5: In the Format Axis window, pick the third option Axis Options. Let us go through the options you can use:
Automatic – Excel does the heavy lifting for you, and determines what the size of each bin would be.
Bin width – You tell Excel how many units each bin should be. In our example below, we are telling Excel that we want each bin to cover 9,984 units each.
Number of bins – Excel will automatically determine the size of each bin, however you can modify the number of bins.
Overflow bin – This will set a threshold for your bins, any value above this threshold will be placed in this bin.
Underflow bin – This will set a threshold for your bins, any value below this threshold will be placed in this bin.
STEP 6: Try out the following settings to modify the Histogram Chart:
Number of Bins – 20
Overflow Bin – 90,000
Underflow Bin – 20,000
Now you have your cool Histogram chart and you can quickly point out to your management which range of values are the most common ones…