How to Create a Frequency Histogram in Excel

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.
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.
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.'
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.