Assuming you already have a xy scatter chart you can either use the
Source Data dialog to add a new series and then select the cells for the
x and y values. Or you can select the 2 columns of data and drag and
drop them onto the chartobject. The paste special dialog should be
displayed. Make sure the New Series option is ticked and also check
Categories X values in first column.