How to Make a Frequency Distribution Graph in Excel for Mac 2011. ... From that calculation you can then create a graph which shows the frequency distribution of the data you've collected.

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.

In the example, you might enter "20," "40," "60," "80" and "100" in cells B1 through B5 to find the frequency distribution of scores in ranges of 20 points each.

Microsoft Excel is capable of many things, and that includes the ability to create histograms with relative ease. Not everyone knows how to create a Histogram , but there might come a time when ...