Prev: Selecting a point on a chart in Excel 2007 on Windows 7
Next: Copying Excel 2007 Charts as picture (as seen on screen)
From: marti003 on 16 Apr 2010 14:22
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!
From: marti003 on 16 Apr 2010 14:31


"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!
From: Bernard Liengme on 16 Apr 2010 15:38
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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"marti003" <marti003(a)discussions.microsoft.com> wrote in message
news:031B8F86-E8DF-46B2-B5C4-595CFD5D5448(a)microsoft.com...
>
>
> "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!

 | 
Pages: 1
Prev: Selecting a point on a chart in Excel 2007 on Windows 7
Next: Copying Excel 2007 Charts as picture (as seen on screen)