Chart types

Hi Sophie
In 2007 when you create a chart and click on the chart you have the Design, Layout and Format contextual tabs. Design is where you will be able to change the layout of the scatter chart by selecting the chart layout group.

In Excel 2003 it is possible to create the line

First select the series in the chart clicking on one data point will select them all

Second go to the chart menu (it will be between tools and Window and will appear when the chart is selected) and select add trendline.

The trendline dialog box will be displayed select type linear.
You should now have a line in the chart

Hope that helps

Any queries don't hesitate to get back to me.

Yours

Newson