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.