Fit bell curve to histogram

[cwinters]

I have created a histogram of event frequencies (into numbered bucket
e.g. 1-5, 5-10, 15-20, etc as x axis labels) using a barchart with zer
gap width.

I'd like to overlay these bars with a smooth curve showing the norma
(bell shaped) distirbution of these frequencies around their mean. An
ideas how to do that

 

[Mike Middleton]

cwinters -

One way is to create a combination chart by adding a data series as the XY
(Scatter) chart type to your currrent Column chart type. And one way of
creating the combo chart is described in a write-up on the Better Histogram
page at www.treeplan.com. But that write-up only uses the XY series to get a
better horizontal axis. You can substitute normal density values using
NORMDIST for that dummy series to show a bell-shaped curve.

- Mike
www.mikemiddleton.com