You can create a simple histogram with a column of measurement data and a corresponding column of frequency data.
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.