How to make a frequency chart

Written by hunter taylor
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to make a frequency chart
(Image courtesy of Microsoft Office online)

Sometimes it is necessary to know how often an event occurs. For example, how often does it rain during a particular hour of the day or the distribution of grades in a class? It is easier to display this information in a chart. In this case, Microsoft Excel is an excellent tool for displaying the frequency of a particular event. Microsoft Excel calls a frequency chart a histogram. In other words, in Excel a frequency chart is equivalent to a histogram. Learn how to create a histogram in Microsoft Excel.

Skill level:
Easy

Other People Are Reading

Things you need

  • Microsoft Excel

Show MoreHide

Instructions

  1. 1

    Create a dataset of student grades; include student names and the grades 50, 60, 70, 80, 90 and 100. Enter or sort the grades in ascending order.

    How to make a frequency chart
    Dataset in ascending order
  2. 2

    Create a bin range of 50, 60, 70, 80, 90 and 100 and enter or sort it in ascending order.

    How to make a frequency chart
    Bin range sorted in ascending order
  3. 3

    Go to "Data Analysis." In older versions of Excel, go to "Tools," "Data Analysis."

    How to make a frequency chart
    Data Analysis option
  4. 4

    Click on "Histogram," then click "OK." A frequency chart is also considered a Histogram.

    How to make a frequency chart
    Histogram option under Data Analysis
  5. 5

    Select the "Input Range" of the histogram. Click on the box beside the field.

    How to make a frequency chart
    Histogram dialogue box
  6. 6

    Highlight the "Input Range" which is the "Grade" column. Click on the box again to return to the histogram dialogue box.

    How to make a frequency chart
    Select the Input Range
  7. 7

    Select the "Bin Range" of the histogram. Click on the box beside the field and highlight the "Bin Range" column.

    How to make a frequency chart
    Select the Bin Range
  8. 8

    Click on the box beside the field to return to the "Histogram" dialogue box.

    How to make a frequency chart
    Histogram dialogue box
  9. 9

    Click on the "Labels" check-box and the "Output Range" button. The Labels check-box tells Excel that there are labels in the dataset. The Output Range tells Excel where to place that information that will feed the frequency chart or histogram.

    How to make a frequency chart
    Label & place the dataset
  10. 10

    Select the "Output Range" using the same steps as the selection of the Input and Bin Ranges. However, select only one cell. In this case, cell E14 was selected. Return to the "Histogram" dialogue box.

  11. 11

    Click the "Chart Output" box which will generate the frequency (histogram) chart.

  12. 12

    Click "OK" to generate the frequency chart.

Tips and warnings

  • The information for the histogram comes from the data table beside it. The size of the histogram can be adjusted by grabbing the chart's edges. Double-click the histogram's labels to change the names. Load the Data Analysis toolpack if it is not readily available in the menu options.
  • If any information is changed in the original dataset, the histogram will need to be remade.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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