Scatter Graph

This used to be so much simpler on excel 2003. I've created the data table and all i want to do is create a scatter graph where x is plotted against y. Because i'm trying to do a S-N Curve. All i can seem to is this :

http://img123.imageshack.us/my.php?i...2320680eq1.jpg

Also i would like to change the no of cycle into log scale if that's possible. Thanks in advance for any help.

Something like this:

http://img360.imageshack.us/my.php?image=graphwk9.jpg

It would be simpler if you had you data laid out in a way excel was expecting.
For scatter it expects X and then Y values.

If you create a xy-scatter on the data in column B this will give you the correct Y values and default X values.
Use the Chart Tools > Design > Select Data > Edit. dialog to select required X range.
Apply data labels.