Remove Connnecting Lines from Line Chart?

[marti003]

Help! 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!

 

[marti003]

:

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!

 

[Bernard Liengme]

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/help/HA102004991033.aspx
Google with search term: excel chart tutorial 2007

best wishes