Select the range of cells, E2:H10, on the worksheet.
Microsoft Excel 97
------------------
a. On the Insert menu, click Chart.
b. In Step 1 of 4, click XY (Scatter). In the 5 charts listed under
"Chart sub-type", in the middle row, click the chart on the
right.
Just below these 5 sub-types, the description will say "Scatter
with data points connected by smoothed lines without markers."
c. Click Next.
d. In Step 2 of 4, click the Series tab.
There will be one series, called "Frequency", listed on this tab.
e. In the "Name" RefEdit box, delete the cell reference, and then
highlight cell E15.
f. In the "X Values" RefEdit box, delete the range reference, and
then highlight the range E3:E10.
g. In the "Y Values" RefEdit box, delete the range reference, and
then highlight the range F3:F10.
h. Click Add to add another series.
i. Click in the "Name" RefEdit box, and then highlight cell E14.
j. Click in the "X Values" RefEdit box, and then highlight the
range E3:E10.
k. Click in the "Y Values" RefEdit box, delete the value that's
there, and then highlight the range G3:G10.
l. Click Add to add another series.
m. Click into the "Name" RefEdit box, and then highlight cell E16.
n. Click into the "X Values" RefEdit box, and then highlight the
range E3:E10.
o. Click into the "Y Values" RefEdit box, delete the value that's
there, and then highlight the range H3:H10.
p. Click Finish.
The chart will have two curved series and a flat series along the
x-axis.
q. Double-click the second series; it should be labeled "...- Bin"
in the legend. In the Format Data Series dialog box, click the
Axis tab. Click the "Secondary Axis" option in the "Plot Series
On" group box.
r. Click OK.
You now have a chart that compares a given data set to a bell
curve.
Microsoft Excel versions 5.0 and 7.0
------------------------------------
a. On the Insert menu, click Chart, and then As New Sheet. Click
Next.
b. Click XY (Scatter), and then click Next.
c. Click Chart type 6, and then click Finish. The chart will have
two curved series and a flat series along the x-axis.
d. Double-click the second series; it should be labeled "Bin" in
the legend. In the Format Data Series dialog box, click the Axis
tab. Click the Secondary Axis button in the "Plot Series On
group" box.
e. Click the Names and Values tab. In the Name box, type the
following, and then click OK:
=Sheet1!$E$14
f. Double-click again with the series still highlighted and click
the Patterns tab. Set the Line pattern to automatic and click OK.
g. Double-click the first series; it should be the first
"Frequency" labeled in the legend. In the Format Data Series
dialog box, click the Names and Values tab. In the Name box,
type the following, and then click OK:
=Sheet1!$E$15
h. Double-click the third series; it should be the only "Frequency"
labeled in the legend. In the Format Data Series dialog box,
click the Names and Values tab. In the Name box, type the
following, and then click OK:
=Sheet1!$E$16
You now have a chart that compares a given data set to a bell
curve.