How to change bin size in Excel

You can watch a video tutorial here.

Histograms are used to organize data in a way that is easy to understand. A histogram tells you the frequency or how often an event occurs. The frequency values are organized as bins or ranges of values. When you create a histogram in Excel, it automatically creates bins based on the data. You may want to change the bin size to make the chart easier to understand. 

Step 1 – Open the Format Axis box

– On the chart, click on the axis
– Right-click and select Format Axis from the context menu

Step 2 – Change the bin width

– Increase the bin width to 10

Step 3 – Check the result

– The size of the bins changes to 10