I have a frequency chart, can show the graph in column charts, but I
want to map a normal distribution over the top.
so far I generated a normal distribution through the normdist function,
but I couldn't get an accurate stdev, and the curve was always centred
across the 15 x values instead of centring on the mean. Any ideas on a
good way to map a normal distribution, or possible ways of centering
what i have created over the mean rather than the 15 x values i have.
thanks


--
oz_orlando
------------------------------------------------------------------------
oz_orlando's Profile: http://www.excelforum.com/member.php...o&userid=31011
View this thread: http://www.excelforum.com/showthread...hreadid=506870

oz_orlando -

Here's my reply to a similar question several months ago:

One way is to use a combination chart, with a Column chart type for the
vertical histogram bars and an XY (Scatter) chart type for the normal
density curve.

You could start with the chart generated by my free Better Histogram add-in,
available at www.treeplan.com, which produces a combination chart (so that
the horizontal axis is more properly labeled), and then you could change
that chart's XY (Scatter) data series to be based on worksheet data using
NORMDIST for the curve. You must be careful about scaling so that the Column
chart type and the XY (Scatter) chart type are aligned correctly.

- Mike
www.mikemiddleton.com

"oz_orlando" wrote
in message ...

I have a frequency chart, can show the graph in column charts, but I
want to map a normal distribution over the top.
so far I generated a normal distribution through the normdist function,
but I couldn't get an accurate stdev, and the curve was always centred
across the 15 x values instead of centring on the mean. Any ideas on a
good way to map a normal distribution, or possible ways of centering
what i have created over the mean rather than the 15 x values i have.
thanks
--
oz_orlando