Well, the question is - is your data normally destributed? Show us a sample
of the data.
I think you will first need to sort on the x-axis data then use a formula
such as
=NORMDIST(A1,AVERAGE($B$1:$B$18),STDEVP($B$1:$B$18 ),FALSE)
depending on the data you would need to plot this on a secondary axis or
normalize it.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Rene" wrote:
How do I chart a normal distribution curve using a scatter plot?
I plotted a bell curve using
http://www.tushar-tehta.com/excel/ch..._distribution/ but I can't
seem to figure out how to plot using my own data.
Using excel 2007
Thanks for your help