I have tried to utilise the existing examples provided such as the one at http:/
ID: 3563568 • Letter: I
Question
I have tried to utilise the existing examples provided such as the one at http://support.microsoft.com/kb/213930.
This example is great but I have some questions which arise. Item numbers 1- 14 are fine.
1. #15 says click "next" but in 2010 this does not exist, but there is an "Ok" button. Clicking OK creates the chart, but reading #16 makes me wonder if I have missed a step(s)?
2. #17 discusses a "name" box. Where is this and where do I find it? What does this step and those that follow which are similarly not in 2010 do?
3. Do steps #18 onward simply provide a better presentation?
4. Are steps #18 onward critical to the bell curve itself?
5. Do steps #18 onward create the Standard deviation lines and colour the various segments???
I sincerely trust that someone is able to assist me with thiss.
Explanation / Answer
After creating the scatter chart, click Select Data.
Delete the existing series, then click Add to create a new series.
Use E15 as name, E3:E9 as X-values and F3:F9 as Y-values.
Click OK.
Click Add again.
Use E14 as name, E3:E9 as X-values and H3:H9 as Y-values.
Click OK twice.
Activate the Layout tab of the ribbon.
Select the second series from the dropdown.
Click Format Selection.
Specify that this series will be plotted on the secondary axis.