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
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/
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.