The frequency distribution is shown in a column chart. Note, you can choose a line chart, bar graph or XY Scatter chart, if those suit your data presentation better. Advertisement ...

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.

A Mini Excel spreadsheet will appear; edit the spreadsheet. When the Mini Excel spreadsheet appears, it will show you an example of how to format the Histogram chart. Enter some frequencies into ...