A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Remove Connnecting Lines from Line Chart?



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2010, 07:22 PM posted to microsoft.public.excel.charting
marti003
external usenet poster
 
Posts: 2
Default Remove Connnecting Lines from Line Chart?

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!
  #2  
Old April 16th, 2010, 07:31 PM posted to microsoft.public.excel.charting
marti003
external usenet poster
 
Posts: 2
Default Remove Connnecting Lines from Line Chart?



"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!
  #3  
Old April 16th, 2010, 08:38 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 516
Default Remove Connnecting Lines from Line Chart?

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!


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.