How to Make a Frequency Distribution Graph in Excel for Mac 2011. ... Select "Normal" in the "Distribution Box" menu. Type the number you see in Cell "B2" in the "Mean" field.

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

Here, select the “Normal Distribution” chart and click the “OK” button. 8] The bell curve is ready. There are many customization options in the bell curve.