If you do not specify the bin range, Excel will create a set of evenly distributed bins between the minimum and maximum values of your input data range.Ĭonsidering the above, type the bin numbers that you want to use in a separate column.If your input data contain any values greater than the highest bin, all such numbers will be included in the More category.

A value is included in a certain bin if it is greater than the lowest bound and equal to or less than the greatest bound for that bin.

The intervals must be consecutive, non-overlapping and usually equal size.Įxcel's Histogram tool includes the input data values in bins based on the following logic: Now, the Analysis ToolPak is loaded in your Excel, and its command is available in the Analysis group on the Data tab.īefore creating a histogram chart, there is one more preparation to make - add the bins in a separate column.īins are numbers that represent the intervals into which you want to group the source data (input data). If Excel shows a message that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

In the Add-Ins dialog box, check the Analysis ToolPak box, and click OK to close the dialog.

In the Excel Options dialog, click Add-Ins on the left sidebar, select Excel Add-ins in the Manage box, and click the Go button.

In Excel 2007, click the Microsoft Office button, and then click Excel Options.

In Excel 2010 - 365, click File > Options.

To add the Data Analysis add-in to your Excel, perform the following steps: However, this add-in is not loaded automatically on Excel start, so you would need to load it first. The Analysis ToolPak is a Microsoft Excel data analysis add-in, available in all modern versions of Excel beginning with Excel 2007. How to create a histogram in Excel using Analysis ToolPak The following screenshot gives an idea of how an Excel histogram can look like: In other words, a histogram graphically displays the number of elements within the consecutive non-overlapping intervals, or bins.įor example, you can make a histogram to display the number of days with a temperature between 61-65, 66-70, 71-75, etc.

A histogram is a specific use of a column chart where each column represents the frequency of elements in a certain range. Have you ever made a bar or column chart to represent some numerical data? I bet everyone has. Wikipedia defines a histogram in the following way: ' Histogram is a graphical representation of the distribution of numerical data.' Absolutely true, and… totally unclear :) Well, let's think about histograms in another way.

How to make histogram on excel