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.

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.

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.