Thats how to do it for 2007.

-------
Some people are gay. Get over it.

Thats in Excel 2007 tho

With the two columns highlighted create a new chart:

Insert→Chart→Chart type=XY(Scatter)

Make sure you select the XY(Scatter) NOT Chart type=Line

If you select all the default options your chart will look something like this:
Default Excel chart

This won't get you many marks, you will have to change just about everything on the graph to bring it up to an acceptable standard.

Below is an improved version of the graph that would be suitable if you have a colour printer. For a black and white printer get rid of the blue squares completely and make the points and line black as well.

-------
Health site

---

http://www.homeandlearn.co.uk/excel2007/excel2007s3p11.html

Thats how to do it for 2007.

---

Hey,

Thanks for such a nice link, now it would be easy to operate excel 2007.
--------------------------------------------
sunred
Tila Tequila Video from Vringo - the one I downloaded...