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.
