How to Create a Frequency Histogram in Excel

By Mark Kennan

Microsoft Excel is a spreadsheet program that allows users to create, among other things, a frequency histogram. A frequency histogram is a graph that shows the number of occurrences of certain events, categories or scores. Histograms differ from bar graphs because the categories must be sequential. For example, you could make a histogram of grades because the numerical grades are sequential but you could not make a histogram of pet types because cats, dogs and hamsters and not sequential.

Step 1

Type the title of your data in cell A1 and enter your data below it. For example, if you were creating a frequency histogram of grades on a test, you would type "Grades" in cell A1 and then type the numerical grades in the cells below.

Step 2

Enter the bin values that you want to use in a separate column. The bins are the values that will be grouped together. For example, if your grading scale was: 90 and up is an A; 80 to 89 is a B; 70 to 79 is a C; 60 to 69 is a D, and 59 and below is an F, you would enter 59, 69, 79, and 89.

Step 3

Select the "Data Analysis" option from the Data tab then select "Histogram." Enter the cells that you typed your data in, for example A2:A19, into the "Input Range" and then enter the cells that you typed your bins into the "Bin Range."

Step 4

Chose whether to have the histogram appear as an item in the existing spreadsheet or on its own in a new sheet then click "OK." The histogram will show up where you have specified.