Thread: Line, xy charts
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
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