Creating a scatter chart

[francop]

Hi everyone!

I'm stuck trying to create a custom scatter chart.

I have the following columns:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Angle n0[/TD]
[TD]Value[/TD]
[TD]Angle n1[/TD]
[TD]Value[/TD]
[TD]Angle n2[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]Frank[/TD]
[TD]5[/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD]22[/TD]
[TD]23[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD]7[/TD]
[TD]15[/TD]
[TD]17[/TD]
[TD]33[/TD]
[TD]28[/TD]
[TD]38[/TD]
[/TR]
</tbody>[/TABLE]

I need a chart with Angles (n0, n1 and n2) in the x-axis and Values in the y-axis, showing 2 series (Frank and Peter).

n0 has angles between 0 and 9, n1 between 10 and 19, and finally n2 has angles between 20 and 29 (just in case).

I appreciate if someone can give me a solution step by step if it's possible.

Thanks in advance!

 

[Jon Peltier]

You need to rearrange your data into two blocks, one for Frank and the other for Peter (see screenshot below). Each one should have a column of X values ("Angle") and another of Y values ("Value"). Put the person's name above the Y values and the names will become series names and will appear in the legend.

Select the data for Frank (including the blank cell at the top left), and insert a scatter chart (first chart in the screenshot). Copy the data for Peter (including the blank cell), select the chart, and on the Home tab of Excel's ribbon, click the little triangle on the Paste button, and choose Paste Special. Select the options shown in the dialog: New Series, Values in Columns, Series Names in First Row, Categories (X Values) in First Column, and click OK.

Peter's data will be added as a new series in the (bottom) chart. The title disappeared, so I had to add it back, and I had to add the legend.