Follow these steps (the numbers relate to the pictures). You insert a PivotChart and use the function to group the data.
The second method also works with Excel versions before 2016. Now you can proceed defining the layout, e.g. Number 6 on the screenshots shows the result, if you set the bin width to “1.0”, the overflow bin to “6.0” and the underflow bin to “2.0”.Excel then summarizes all items below the underflow bin into one column on your chart. Also important: Do you want to set an individual “underflow” bin or and “overflow” bin.Alternatively, you can let Excel define the bins automatically or define the number of bins.By default, it’s “Automatic”. You could switch it to “Bin width” and set the desired class width, e.g. Most important is probably the “Bin width”.
Under “Axis Options”, you can set the main preferences. To achieve this, double click on the x-Axis. Since Excel 2016, there is a built-in chart type called “histogram”.
