Line, xy charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Deb - 27 Feb 2007 14:00 GMT

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.

Signature

D.White

Reply to this Message

Bernard Liengme - 27 Feb 2007 15:01 GMT

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

Signature

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

>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,
[quoted text clipped - 4 lines]
> to all the data points within the series. Can you please help me fix this
> problem.

Reply to this Message