a) when you make the chart: select Insert | Line and from the gallery pick
the first one in the second row
b) to modify existing chart:
1) right click chart; select Change Chart Type and select the Line chart
that shows only data points
2) right click the data series in the chart; use Format Data Series and
format to have no lines and markers to suit your need

Have a look at his site
http://office.microsoft.com/en-us/he...004991033.aspx
Google with search term: excel chart tutorial 2007

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"marti003" wrote in message
...


"marti003" wrote:

I am using Excel 2007. I want a line chart that only shows data points,
not
lines in between. A scatter chart doesn't work correctly with the data.
How
do I remove the connecting lines from a line chart and just show the data
points? Help is appreciated!