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!

Sure, I can help you with that! Here are the steps to remove the connecting lines from a line chart in Microsoft Excel:

1. Select the line chart that you want to modify.
2. Click on the "Design" tab in the ribbon at the top of the screen.
3. Click on the "Change Chart Type" button in the "Type" group.
4. In the "Change Chart Type" dialog box, select the "Scatter" chart type.
5. Choose the subtype of scatter chart that you want to use (e.g. "Scatter with Straight Lines and Markers").
6. Click "OK" to close the dialog box and apply the changes to your chart.
7. Your chart should now display only data points without any connecting lines.

That's it! You should now have a scatter chart that displays your data points without any connecting lines. If you have any further questions or need additional help, feel free to ask.

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

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!