Then, choose your preferred style from the drop-down.Īs a result, you will have your preferred Chart Style applied to your Histogram chart.Firstly, click on the Chart Styles option as marked in the image below.Read More: How to Make a Histogram in Excel with Two Sets of Data (4 Ways) Next, check the field of the Underflow bin and enter 60 here.Ĭonsequently, your Histogram chart will be looking like the following image, which looks a lot better than the previous one.Then, check the field of the Overflow bin and enter 90 here.Following that, click on the field of Bin width and enter 10 in it.Now, in the Format Axis dialogue box, go to the Axis Options tab.Subsequently, the Format Axis dialogue box will open on your worksheet. Firstly, double-click on the Horizontal Axis of the Histogram chart as marked in the following image.

Step 02: Edit Horizontal Axis of Histogram Chart Read More: How to Create a Histogram in Excel with Bins (4 Methods) Let’s follow the methods below to resolve this problem. You can see that this Histogram doesn’t look well and that the Bin Ranges aren’t formatted correctly. Then, choose the Histogram option from the drop-down.Īs a result, the following Histogram chart will be added to your worksheet.Following that, click on the Insert Statistic Chart option.Firstly, select the entire dataset and go to the Insert tab from Ribbon.In the first solution, we will use the default Histogram chart option provided by Excel. Solution 01: Using Format Axis Option from Default Histogram Chart Not to mention that we have used the Microsoft Excel 365 version for this article, you can use any other version according to your convenience. In each solution, firstly, we will see a case where Bin Range is not working and later on we will learn the detailed steps to fix it. Let’s say we have Marks of 6th Grade Students of a school. 3 Solutions If Histogram Bin Range Is Not Working in Excel

Excel histogram bin size