The result is technically a Histogram chart, but it doesn’t really tell the story in the way we need.
We will improve the chart with the following modifications:
Setting the Bin Width
The groupings of data points are known as “bins”. We can define the bin logic in two ways: either by the width of the bins (i.e. size) or the number of bins.
NOTE: “Automatic” is another option, but it rarely proves useful.
To decide on the strategy and set the parameters, double-click the values along the X-Axis (or single-click the values and press CTRL-1) to reveal the Format Axis panel.
If we set the Bin Width to 40,000, the result is 6 bins ranging from approximately 21K to 261K in increments of 40K.
Not great but getting better.
Creating an Overflow Bin
The purpose of the Overflow bin is to capture all values over a certain range.
For our chart, we will define the Overflow bin to hold all values over 200K.
Creating an Underflow Bin
The purpose of the Underflow bin is to capture all values below a certain range.
For our chart, we will define the Underflow bin to hold all values under 30K.