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.

Making a histogram in excel