How to Create a Frequency Histogram in Excel

Written by michael keenan
  • Share
  • Tweet
  • Share
  • Email

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.

Skill level:
Moderately Easy


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

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.