Line, xy charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top