PDA

View Full Version : Graphing a bell curve from an Excel data series



larryt1940
01-12-2012, 08:56 PM
Is there a method to graphing a bell curve from a data series in Excel 2007? :confused:

Thanks for your help.

Excel Fox
01-13-2012, 01:01 AM
You can check these files

www.grahamseibert.com/MK/math/bell_curve.xls
xnet.rrc.mb.ca/davidg/Excel/bellcurve.xls

Rasm
01-24-2012, 06:08 AM
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/making-histogram-chart-using-arrays-14/