How do I set up a Y-scatter chart?

[Guest]

How do I set up a Y-scatter chart?

My data are site 1 (values 0.1, 2, 3, 4.5 ) and site 2 (0.2, 4, 5, 10.5)? I
want the x-axis to be fixed with the site name and y-axis variable with the
data.

 

[Bernard Liengme]

This is not an XY scatter but a Line chart becaue your x-values are
categories not numeric value
In A1 enter the text Site 1, in B1 the text Site 2
In A2:A5 enter values 0.1, 2,3,4.5; in B2:B5 enter 0.2, 4,5,10.5
Select A1"B5, click on Chart Wizard, Specify LINE chart
In Stage 2 of Chart wizard change BY COLUMN to BY ROW
Continue to end of Chart Wizard