Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Merging 3 Charts into 1
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Merging 3 Charts into 1
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Merging 3 Charts into 1
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Merging 3 Charts into 1
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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Merging 3 Charts into 1
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 |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Merging 3 Charts into 1
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 |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Merging 3 Charts into 1
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 |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Merging 3 Charts into 1
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 |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
Merging 3 Charts into 1
Thank you...It completed succeeded...now I have three normal curves
superimposed on one set of X axis...eventhough there are 3 distinct sets of X values in the chart. I had, on my own, previously succeed by using the VLOOKUP function and pasting the 3 sets of Y values onto a range of artificially created X values which represent the 'maximum' range of my 3 sets of X values. The trouble with that is I get values pasted to, say the X value is 100, but my three Y values are 99.5, 100.7, and 101.8 -- that would all paste to 100 with the VLOOKUP formula...making my bell curve skewed. Nevertheless, I was still pleased... but, your way is much better!! Thank you, FLKulchar "Jon Peltier" wrote in message ... 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 |
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
Merging 3 Charts into 1
I made a mistake on my last posting:
The trouble with that is I get values pasted to, say the X value is 100, but my three X values are 99.5, 100.7, and 101.8 -- that would all paste to 100 with the VLOOKUP formula...making my bell curve skewed. Nevertheless, I was still pleased. Change "Y" to "X". Thank you... FLKulchar "FLKulchar" wrote in message ... Thank you...It completed succeeded...now I have three normal curves superimposed on one set of X axis...eventhough there are 3 distinct sets of X values in the chart. I had, on my own, previously succeed by using the VLOOKUP function and pasting the 3 sets of Y values onto a range of artificially created X values which represent the 'maximum' range of my 3 sets of X values. The trouble with that is I get values pasted to, say the X value is 100, but my three Y values are 99.5, 100.7, and 101.8 -- that would all paste to 100 with the VLOOKUP formula...making my bell curve skewed. Nevertheless, I was still pleased... but, your way is much better!! Thank you, FLKulchar "Jon Peltier" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple pie charts and merging them into word. | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
mail merging dynamic charts | Charts and Charting in Excel | |||
When merging information not merging correctly | Excel Worksheet Functions | |||
Sorting, Merging, and Re-merging | Excel Worksheet Functions |