Create a histogram with frequency data

You can create a simple histogram with a column of measurement data and a corresponding column of frequency data.

C1 C2
Scores Frequency
53 2
56 3
58 3
... ...
Example worksheet and graph

In this worksheet, Scores contains test scores and Frequency contains the number of times the scores occurred. This histogram shows the distribution of test scores.


If your data are categorical, for example, you have letter grades instead of scores, you can create a bar chart of a function of a variable (sum) and make it look like a histogram. Create the bar chart and double-click the X-axis. Under Space Between Scale Categories deselect Auto for Gap between clusters and enter 0.

  1. Choose Graph > Histogram.
  2. Choose Simple, then click OK.
  3. Under Graph variables, enter the column of numeric or date/time data. In the example, Scores is the graph variable.
  4. Click Data Options, then click the Frequency tab.
  5. Under Frequency variable(s) enter the column that contains the frequency, or counts, data. In the example, Frequency is the frequency variable.
  6. Click OK in each dialog box.
  7. (Optional) To display percents, double-click the y-axis. Click the Type tab. Under Scale Type choose Percent, then click OK.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy