Is there a method to graphing a bell curve from a data series in Excel 2007? :confused:
Thanks for your help.
Printable View
Is there a method to graphing a bell curve from a data series in Excel 2007? :confused:
Thanks for your help.
You can check these files
www.grahamseibert.com/MK/math/bell_curve.xls
xnet.rrc.mb.ca/davidg/Excel/bellcurve.xls
The link below makes a Histogram (based upon real data - so the chart may not be normally distributed) - you can simply change the chart type to i.e. .ChartType = xlXYScatterLinesNoMarkers - that way it draws a line rather than using bars - you can change the number bins - this will give the curve more or less character. But if you actually want a Bell curve this is not the answer.
http://www.excelfox.com/forum/f12/ma...ing-arrays-14/