Follow to insert an X Y chart, but you need a data that looks something like this:
Click insert, after marking the whole data (which in this case, is from A2 to C9).
Click on XY chart
Choose desired design for your chart
Note: Scatter chart is the XY chart.
The newly created XY chart: