How to Graph a Normal Distribution Curve in Excel 2007

1. Enter the number -4 into cell A2.
2. Select the cell with your mouse. Click on the down arrow under 'Fill' in the Editing group to the far right on the ribbon (the toolbar). Choose 'Series.' A pop-up will appear.
3. Click on the radio buttons to choose 'Columns and Linear.' Type .25 into the 'Step Value' box and 4 into the 'Stop' box. Press 'OK.' This should fill column A with the x-values for the normal distribution.
4. Type =NORMDIST(A2,AVERAGE($A$2:$A$34),STDEV($A$2:$A$34),FALSE) into cell B2. This calculates the mean and standard deviation from your x-values and also creates your first y-value in cell B2.
5. Copy the formula that you typed in Step 4 by highlighting the cell and dragging the fill tool (the tiny square at the bottom right) down to cell B34. This creates all of your y-values.
6. Select the 'Insert' tab from the ribbon. Click on the down arrow next to 'Scatter' and choose 'Scatter With Smooth Lines and Markers.'