I have three charts, each of which shows a normal curve (bell shaped) with 3
different means and 3 different standard deviations. Taken individually, the
3 charts are a "masterpiece."

However, I wish to merge the three charts into one so I can show the 3 bell
shapes on one graph. The best way to further explain is to cite this example:

Chart 1 X axis 10 through 160
mean 80
std. dev. 20

Chart 2 X axis 60 through 120
mean 90
std. dev. 10

Chart 3 X axis 20 through 150
mean 85
std. dev. 25

In other words, the data points overlap for each graph; however, the 'width'
of the X axis is different for each graph; in addition, the height (mean) of
each graph is, also, markedly, different.

HOW CAN I MERGE THESE THREE GRAPHS TOGETHER TO SHOW ONE GRAPH WITH THE 3
BELL CURVES?

Thanks,

FLKulchar

F. Lawrence Kulchar -

Here's one way:

Create three sets of X and Y (=NORMDIST) values on a worksheet.

Create an XY (Scatter) chart type for one of the XY sets.

Use the Chart Source Data option to add each of the other two XY sets.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"F. Lawrence Kulchar" wrote in
message ...
I have three charts, each of which shows a normal curve (bell shaped) with
3
different means and 3 different standard deviations. Taken individually,
the
3 charts are a "masterpiece."

However, I wish to merge the three charts into one so I can show the 3
bell
shapes on one graph. The best way to further explain is to cite this
example:

Chart 1 X axis 10 through 160
mean 80
std. dev. 20

Chart 2 X axis 60 through 120
mean 90
std. dev. 10

Chart 3 X axis 20 through 150
mean 85
std. dev. 25

In other words, the data points overlap for each graph; however, the
'width'
of the X axis is different for each graph; in addition, the height (mean)
of
each graph is, also, markedly, different.

HOW CAN I MERGE THESE THREE GRAPHS TOGETHER TO SHOW ONE GRAPH WITH THE 3
BELL CURVES?

Thanks,

FLKulchar

I will definitely try this...and let you know what happened; it seems to me
that the first XY scatter plot (which I have been using) will be
perfect,,,,if I add lists 2 and 3, will EXCEL associate these Y values with
the proper X values (already established...as the X axis).

Thank you,
FLKulchar
"Mike Middleton" wrote in message
...
F. Lawrence Kulchar -

Here's one way:

Create three sets of X and Y (=NORMDIST) values on a worksheet.

Create an XY (Scatter) chart type for one of the XY sets.

Use the Chart Source Data option to add each of the other two XY sets.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"F. Lawrence Kulchar" wrote
in message ...
I have three charts, each of which shows a normal curve (bell shaped) with
3
different means and 3 different standard deviations. Taken individually,
the
3 charts are a "masterpiece."

However, I wish to merge the three charts into one so I can show the 3
bell
shapes on one graph. The best way to further explain is to cite this
example:

Chart 1 X axis 10 through 160
mean 80
std. dev. 20

Chart 2 X axis 60 through 120
mean 90
std. dev. 10

Chart 3 X axis 20 through 150
mean 85
std. dev. 25

In other words, the data points overlap for each graph; however, the
'width'
of the X axis is different for each graph; in addition, the height (mean)
of
each graph is, also, markedly, different.

HOW CAN I MERGE THESE THREE GRAPHS TOGETHER TO SHOW ONE GRAPH WITH THE 3
BELL CURVES?

Thanks,

FLKulchar

OKay..I have tried it; the added normal curves do NOT associate the Y value
with the proper X value -- it associates it with the range referenced cell,
ie on the same horizontal plane!

FLKulchar
"Mike Middleton" wrote in message
...
F. Lawrence Kulchar -

Here's one way:

Create three sets of X and Y (=NORMDIST) values on a worksheet.

Create an XY (Scatter) chart type for one of the XY sets.

Use the Chart Source Data option to add each of the other two XY sets.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"F. Lawrence Kulchar" wrote
in message ...
I have three charts, each of which shows a normal curve (bell shaped) with
3
different means and 3 different standard deviations. Taken individually,
the
3 charts are a "masterpiece."

However, I wish to merge the three charts into one so I can show the 3
bell
shapes on one graph. The best way to further explain is to cite this
example:

Chart 1 X axis 10 through 160
mean 80
std. dev. 20

Chart 2 X axis 60 through 120
mean 90
std. dev. 10

Chart 3 X axis 20 through 150
mean 85
std. dev. 25

In other words, the data points overlap for each graph; however, the
'width'
of the X axis is different for each graph; in addition, the height (mean)
of
each graph is, also, markedly, different.

HOW CAN I MERGE THESE THREE GRAPHS TOGETHER TO SHOW ONE GRAPH WITH THE 3
BELL CURVES?

Thanks,

FLKulchar

I think you need to read again what Mike suggested:
"Use the Chart Source Data option to add each of the other two XY sets."
That option allows you to select the appropriate X and Y data for each
series.
--
David Biddulph

"FLKulchar" wrote in message
...
OKay..I have tried it; the added normal curves do NOT associate the Y
value with the proper X value -- it associates it with the range
referenced cell, ie on the same horizontal plane!

"Mike Middleton" wrote in message
...
F. Lawrence Kulchar -

Here's one way:

Create three sets of X and Y (=NORMDIST) values on a worksheet.

Create an XY (Scatter) chart type for one of the XY sets.

Use the Chart Source Data option to add each of the other two XY sets.

"F. Lawrence Kulchar" wrote
in message ...
I have three charts, each of which shows a normal curve (bell shaped)
with 3
different means and 3 different standard deviations. Taken
individually, the
3 charts are a "masterpiece."

However, I wish to merge the three charts into one so I can show the 3
bell
shapes on one graph. The best way to further explain is to cite this
example:

Chart 1 X axis 10 through 160
mean 80
std. dev. 20

Chart 2 X axis 60 through 120
mean 90
std. dev. 10

Chart 3 X axis 20 through 150
mean 85
std. dev. 25

In other words, the data points overlap for each graph; however, the
'width'
of the X axis is different for each graph; in addition, the height
(mean) of
each graph is, also, markedly, different.

HOW CAN I MERGE THESE THREE GRAPHS TOGETHER TO SHOW ONE GRAPH WITH THE 3
BELL CURVES?

Thanks,

FLKulchar

i am not sure i know how to add XY data for another set of data.

Will I have 3 X axis series?

FLKulchar
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
I think you need to read again what Mike suggested:
"Use the Chart Source Data option to add each of the other two XY sets."
That option allows you to select the appropriate X and Y data for each
series.
--
David Biddulph

"FLKulchar" wrote in message
...
OKay..I have tried it; the added normal curves do NOT associate the Y
value with the proper X value -- it associates it with the range
referenced cell, ie on the same horizontal plane!

"Mike Middleton" wrote in message
...
F. Lawrence Kulchar -

Here's one way:

Create three sets of X and Y (=NORMDIST) values on a worksheet.

Create an XY (Scatter) chart type for one of the XY sets.

Use the Chart Source Data option to add each of the other two XY sets.

"F. Lawrence Kulchar" wrote
in message ...
I have three charts, each of which shows a normal curve (bell shaped)
with 3
different means and 3 different standard deviations. Taken
individually, the
3 charts are a "masterpiece."

However, I wish to merge the three charts into one so I can show the 3
bell
shapes on one graph. The best way to further explain is to cite this
example:

Chart 1 X axis 10 through 160
mean 80
std. dev. 20

Chart 2 X axis 60 through 120
mean 90
std. dev. 10

Chart 3 X axis 20 through 150
mean 85
std. dev. 25

In other words, the data points overlap for each graph; however, the
'width'
of the X axis is different for each graph; in addition, the height
(mean) of
each graph is, also, markedly, different.

HOW CAN I MERGE THESE THREE GRAPHS TOGETHER TO SHOW ONE GRAPH WITH THE
3
BELL CURVES?

Thanks,

FLKulchar

Yes. Each series will use its own set of X data, as well as Y data, as
described by Mike.
--
David Biddulph

"FLKulchar" wrote in message
...
i am not sure i know how to add XY data for another set of data.

Will I have 3 X axis series?

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
I think you need to read again what Mike suggested:
"Use the Chart Source Data option to add each of the other two XY sets."
That option allows you to select the appropriate X and Y data for each
series.

"FLKulchar" wrote in message
...
OKay..I have tried it; the added normal curves do NOT associate the Y
value with the proper X value -- it associates it with the range
referenced cell, ie on the same horizontal plane!

"Mike Middleton" wrote in message
...
F. Lawrence Kulchar -

Here's one way:

Create three sets of X and Y (=NORMDIST) values on a worksheet.

Create an XY (Scatter) chart type for one of the XY sets.

Use the Chart Source Data option to add each of the other two XY sets.

"F. Lawrence Kulchar"
wrote in message
...
I have three charts, each of which shows a normal curve (bell shaped)
with 3
different means and 3 different standard deviations. Taken
individually, the
3 charts are a "masterpiece."

However, I wish to merge the three charts into one so I can show the 3
bell
shapes on one graph. The best way to further explain is to cite this
example:

Chart 1 X axis 10 through 160
mean 80
std. dev. 20

Chart 2 X axis 60 through 120
mean 90
std. dev. 10

Chart 3 X axis 20 through 150
mean 85
std. dev. 25

In other words, the data points overlap for each graph; however, the
'width'
of the X axis is different for each graph; in addition, the height
(mean) of
each graph is, also, markedly, different.

HOW CAN I MERGE THESE THREE GRAPHS TOGETHER TO SHOW ONE GRAPH WITH THE
3
BELL CURVES?

Thanks,

FLKulchar

The easiest way to do this is to have three ranges, each with two columns,
where the first column contains X and the second Y values. Make an XY chart
(not a line chart) using the first XY pair of columns. Copy the second pair
of columns, select the chart, use Edit menu Paste Special to add the data
as a new series, with X values (category labels) in the first column. Repeat
the copy/paste special operation with the third range.

The next easiest way is to make the xy (not line) chart with the first set
of data, then go to Chart menu Source data Series tab. Click Add to add
a series, then click in the X Values box to add X values for the new series,
and in the Y Values box to add Y values. Click Add again to add the third
series and its data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"FLKulchar" wrote in message
...
i am not sure i know how to add XY data for another set of data.

Will I have 3 X axis series?

FLKulchar
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
I think you need to read again what Mike suggested:
"Use the Chart Source Data option to add each of the other two XY sets."
That option allows you to select the appropriate X and Y data for each
series.
--
David Biddulph

"FLKulchar" wrote in message
...
OKay..I have tried it; the added normal curves do NOT associate the Y
value with the proper X value -- it associates it with the range
referenced cell, ie on the same horizontal plane!

"Mike Middleton" wrote in message
...
F. Lawrence Kulchar -

Here's one way:

Create three sets of X and Y (=NORMDIST) values on a worksheet.

Create an XY (Scatter) chart type for one of the XY sets.

Use the Chart Source Data option to add each of the other two XY sets.

"F. Lawrence Kulchar"
wrote in message
...
I have three charts, each of which shows a normal curve (bell shaped)
with 3
different means and 3 different standard deviations. Taken
individually, the
3 charts are a "masterpiece."

However, I wish to merge the three charts into one so I can show the 3
bell
shapes on one graph. The best way to further explain is to cite this
example:

Chart 1 X axis 10 through 160
mean 80
std. dev. 20

Chart 2 X axis 60 through 120
mean 90
std. dev. 10

Chart 3 X axis 20 through 150
mean 85
std. dev. 25

In other words, the data points overlap for each graph; however, the
'width'
of the X axis is different for each graph; in addition, the height
(mean) of
each graph is, also, markedly, different.

HOW CAN I MERGE THESE THREE GRAPHS TOGETHER TO SHOW ONE GRAPH WITH THE
3
BELL CURVES?

Thanks,

FLKulchar