If you are using Excel 2016 or later versions, you can create a histogram in Excel with bins by inserting a statistical chart. Create a Histogram Using Statistic Chart in Excel (for 2016 and Later Versions) Please leave a comment if any part of this article does not work in your version.ġ. Not to mention, here, we have used the Microsoft Excel 365 version you may use any other version according to your convenience. Now, we’ll utilize this dataset to create a histogram chart in Excel with bins using multiple methods. In a practical scenario, you may encounter a much larger and more complex dataset. Note: This is a basic dataset to keep things simple. We also have the number of “Bins” available on the right side of our dataset. This dataset includes the “Sales Rep ID” and the corresponding “Quantity Sold” under columns B and C. How to Create a Histogram in Excel with Bins: 5 Simple WaysĪssume we have Sales Data for a particular organization. This way you can quickly get an overview of the performance of the business on the number of sales reps appearing in those groups. The sales quantity may vary from 0 to 500. On the other hand, the frequencies of data corresponding to each bin are plotted along the vertical axis.Īssume you have the sales data of some sales reps of a certain organization. These bins are plotted along the horizontal axis. All data points are divided into several groups or ranges called Bins. A histogram is a graphical representation of data divided into different groups to show the frequency of data points in each group.

Excel 2016 histogram