PC Review


Reply
Thread Tools Rate Thread

I can't get the lines to connect on my line graph

 
 
=?Utf-8?B?c29sZXNtYXRl?=
Guest
Posts: n/a
 
      9th Nov 2005
I have a line graph and can see the points plotted but the lines are not
connected. What am I doing wrong?
 
Reply With Quote
 
 
 
 
Andy Pope
Guest
Posts: n/a
 
      9th Nov 2005
Hi,

Couple of things to check.
Do you have values for all the points on your line, that is no gaps in
your data. If you have empty cells select the chart and then check, via
the menu Tools > Options, the chart tab settings for plotting empty cells.
Do you have a line style selected, as it is possible to plot points
without a joining line. Double click a point and check the Patterns tab
for formats being applied to the line.

Cheers
Andy

solesmate wrote:
> I have a line graph and can see the points plotted but the lines are not
> connected. What am I doing wrong?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Controlling Lines in a Line Graph PapaV53 Microsoft Excel Charting 1 17th Mar 2010 04:43 PM
How do i get lines on a line graph? baffledbrewer Microsoft Excel Charting 2 4th Jun 2006 01:38 PM
How do i get lines on a line graph? baffledbrewer Microsoft Excel Charting 2 4th Jun 2006 01:31 PM
Line Graph with 2 lines =?Utf-8?B?TmVlZCBoZWxwIG1ha2luZyBsaW5lIGdyYXBoIHdp Microsoft Excel Charting 5 19th May 2006 08:42 PM
Different lines in a spreadsheet on the same line in graph? =?Utf-8?B?TGVpc2hhIFBoaWZlcg==?= Microsoft Excel Charting 1 9th May 2006 08:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:35 AM.