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 ...

When you open Excel and start working with data, you might wonder how to visualize the distribution of your data points. This is where a Histogram Chart comes into play.

Charts are useful to summarize large data, show data categories in a frequency distribution and estimate key values. Follow the steps to make a Run Chart in Microsoft Excel: Launch Microsoft Excel.

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 ...