Select the range on the worksheet. The left column (‘D’) will be the ‘X’ values and the right column (‘E’) will be the ‘Y’ values (we’ll use the data in Column 'F' later):

Now select Chart from the 'Insert' menu. Select a 'scatter' chart:

This will create a chart: