Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
solesmate
 
Posts: n/a
Default I can't get the lines to connect on my line graph

I have a line graph and can see the points plotted but the lines are not
connected. What am I doing wrong?
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default I can't get the lines to connect on my line graph

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
missing data points causes my line graph not to connect liebw Charts and Charting in Excel 8 November 24th 08 10:15 PM
How can I change a graph with 2 bars,2 lines to 3 bars, 1 line? IOWAJulie Charts and Charting in Excel 3 October 19th 05 11:13 PM
line graph ratio Charts and Charting in Excel 1 June 23rd 05 12:41 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Line and Column Graph Nikki Charts and Charting in Excel 3 February 4th 05 04:42 AM


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

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

About Us

"It's about Microsoft Excel"