Now, we have the data to make a histogram chart. Bin values are same and the Frequency is how many values have fallen in specific range. This will have the same output cell that was specified earlier. Output Range, this is the cell where you want the output result of the data.

Input Range, the whole data for which the histogram is to be represented.

The Histogram menu will appear, in which you will have to specify these ranges:

Data Analysis menu Evaluating Histogram Data Data Analysis in the Data tabĬhoose Histogram and click OK. The Data Analysis option is now added in the Data tab on the Ribbon.Ĭlick Data > Analysis > Data Analysis. Adding Analysis ToolPak for Data AnalysisĮnable the Analysis ToolPak and click OK. Bin Rangeīefore making Histogram, we need to enable Data Analysis. We have set the Bin Range as shown in the image. We will need to enter values for the Bin range.

Bin Range : Also called class interval, it is the range of values which are sorted in a histogram for which Frequency is evaluated.

Input Range : All the values for which we want to make the histogram, in this case, the amount of money that was spent by each individual.

To make a Histogram, we need to have two sets of values. We have 50 values of the data in a column, for which we are going to make a Histogram. Histograms are usually used to represent data of any kind, for example, they can be used to represent the Marks obtained by student in a subject.įor this tutorial, the Amount Spent by customers in a shop is used as Input Range of data. We will use numerical data to make a Histogram chart. Histogram is used to represent a distribution of data. In this tutorial, we will learn how to make a Histogram in Microsoft Excel.

Excel histogram bins