View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default normal distribution chart

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