Lastly, I have chosen from the 2-D Column > Clustered Column.

Thirdly, from the Charts group section, you have to select Insert Column or Bar Chart.

Secondly, you have to go to the Insert tab.

Step 2: Inserting Chart to Create Histogram

Subsequently, press ENTER to get the frequencies for English.

Furthermore, you will get the frequency for more than the value of F11 also. Here, D5:D15 is the data array and F7:F11 is the Bins array. Here, in this formula, the FREQUENCY function will count how many times a value comes within a given interval.

Now, select the G7 cell and write the following formula.

Here, I want to see how many students get marks below 40, also between 41 to 50, 51 to 60, 61 to 70, 71 to 80, and more than 81. This means you should write the values about what interval you want to make the Histogram. Here, I will calculate the frequencies in Step 1 and I will show you how to insert a chart in Step 2.

Basically, I will find out the frequencies with the FREQUENCY function and then plot a simple bar graph for creating the Histogram. Here, you can use the FREQUENCY function to make a Histogram with two sets of data in Excel. Use of FREQUENCY Function to Make a Histogram with Two Sets of Data Now, let’s calculate how many students get marks between different intervals. In addition, for your better understanding, I’m going to use a sample dataset. Here, I will describe 4 methods to make a Histogram in Excel with two sets of data. Bins are actually classes or intervals.Ĥ Methods to Make a Histogram in Excel with Two Sets of Data Furthermore, you will see a term named Bins here. Here, the rectangle’s width denotes a certain range as intervals and the height of the rectangle denotes the number of frequencies. Creating Histogram with Two variables.xlsxĪ Histogram is a chart that contains some rectangles.

How to make a histogram excel