Plotting a normal distribution

I don’t use Excel for my statistics but based on a quick read of the help section for the NORMDIST function it appears the function will generate random numbers from a normal distribution with mean 0 and standard deviation = 1.  If this is in fact what it is doing then you should get values greater than 1 and less than -1.

True there is no canned way to plot a normality plot in Excel – unless you purchase one of the many programs that do this.
Here’s a way to do it though:
Assumptions:  raw data are in column A and you have n data values.
1)  Use the RANK function in column B to rank the raw data (use the help to see how to do this)
2)  Use this expression –>  ((column B-.5)/n)   (this is column C)
3)  Use the NORMINV function with column C as the probaility.  (this will be column D)
4) Create a scatter plot with column A as the x-axis and column D as the y-axis. 
 
Try that and see if that meets your needs.

Dear Friend,
There is many more to explore in excel.
Please try the following path & see whether it satisfy your need or not.
1. Select Tools manu -> Add-Ins.
2. One dialog box will appear with many option. Select “Analysis Toolpak”If analysis toolpak is not loaded in your system then ask administator to installed full version of MS-Office.
3. Again goto “Tools Menu” -> select “Data Analysis” option.
4. One dialog box will appear with many option. Select “Histogram” to plot histogram & ND curve for your data.
5. Just follow the instruction appear on the Screen.
Rgds,
Vidyadhar.