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.

9. Present Your Frequency Distribution. Finally, with all necessary calculations complete, present your frequency distribution using a table or graph format of your choice (e.g., bar chart, histogram, ...