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. How to Make a Histogram in Excel with Two Sets of Data: 4 Methods 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. A Histogram is a chart that contains some rectangles.
