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 (well use the data in Column 'F' later):

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

This will create a chart:
