#1   Report Post  
Posted to microsoft.public.excel.charting
Deb Deb is offline
external usenet poster
 
Posts: 102
Default Line, xy charts

I have completed a spreadsheet that I am using to generate a line graph. I
have successfully told excel the area of data in which to plot. However,
when the chart shows up the lines that should be connecting each of the data
points is broken and/or missing. In other words my lines are not connecting
to all the data points within the series. Can you please help me fix this
problem.
--
D.White
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default Line, xy charts

Sounds like missing data.
Suppose you x-values are in A2:A11 and y-values in B2:B11 (text in B1)
You clicked within this range and made a chart.
Look at the x-values on the chart that have no y-values; now look in the
data.
Do you have a blank? If so, replace it with =NA() which displays as #N/A and
is ignored by the chart engine.
Could it be you have text masquerading as number? Retype any y-values that
does not appear on the chart.
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Deb" wrote in message
...
I have completed a spreadsheet that I am using to generate a line graph. I
have successfully told excel the area of data in which to plot. However,
when the chart shows up the lines that should be connecting each of the
data
points is broken and/or missing. In other words my lines are not
connecting
to all the data points within the series. Can you please help me fix this
problem.
--
D.White



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
LINE CHARTS Aurora Excel Discussion (Misc queries) 1 May 9th 06 09:55 PM
LINE CHARTS Aurora Charts and Charting in Excel 1 May 9th 06 05:05 PM
Line - Column Charts DJ Runt Charts and Charting in Excel 1 December 30th 05 05:49 PM
Line Charts andrea New Users to Excel 1 October 7th 05 02:46 AM
Bar and Line Charts Keith Charts and Charting in Excel 1 February 18th 05 09:39 PM


All times are GMT +1. The time now is 02:31 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"