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 |
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 |
All times are GMT +1. The time now is 08:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com