Using the chart function, spreadsheet administrators can generate a chart in a few clicks, choosing a chart type, as well as options such as labels, axes and titles. Advertisement Article ...

To create a chart, select your data, open the "Insert" tab, and click the icon in the corner of the Charts group.

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.