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/