On Thu, 29 Jun 2006, in microsoft.public.excel.charting,
nsv said:

The task is to illustrate the statistical result of a number of
measurements. The standard way is to show the actual measured values as
discreete bars and the estimated normal-distribution as an overlaid
continuous line. All statistics programs do this routinely, but I would
like to do it in Excel.

I'm afraid the combination chart is out of question because the task
requires a large amount of x-values to smooth the line part of the
graph, but the numbers of bars is usually low. The combination chart
can not operate with different number of x's as the xy-chart can.

What you have to do is make it a combination, not of a column series and
a line series, but a column series and a scatter series.

This is perfectly feasible; if you've already got your line series set
up, click on it and select "Chart Type". That will let you turn just
that series into a scatter graph. Now you can put as many points on the
bell curve as you need to make it look smooth.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.