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.