Using a scatter chart automatically plots the ranges against their frequencies, but using a column graph creates a familiar histogram type chart. Open Microsoft Excel and list your data in column A.

To read a histogram in Excel, first install the Analysis ToolPak Excel add-on, then input your data and generate a histogram, with optional chart and cumulative percentage numbers. Install the ...