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 |

... | ... |

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

- Choose .
- Choose Simple, then click OK.
- Under Graph variables, enter the column of numeric or date/time data. In the example, Scores is the graph variable.
- Click Data Options, then click the Frequency tab.
- Under Frequency variable(s) enter the column that contains the frequency, or counts, data. In the example, Frequency is the frequency variable.
- Click OK in each dialog box.
- (Optional) To display percents, double-click the y-axis. Click the Type tab. Under Scale Type choose Percent, then click OK.