XY Chart

Follow to insert an X Y chart, but you need a data that looks something like this:

data table

Click insert, after marking the whole data (which in this case, is from A2 to C9).

ribbon xy

Click on XY chart

click scatter chart

Choose desired design for your chart

scatter chart design


Note: Scatter chart is the XY chart.

The newly created XY chart:

xy chart created