Do not show lack of data as a zero on graph lines, leave blank
 

I used to know this but got new software. If I leave a blank in a line of
data and at the end of the data, the graph line drops to zero. I just want
it to igore blank spaces.

Do not show lack of data as a zero on graph lines, leave blank
 

1) replace blank by =NA(); displays as #N/A
OR
2) click on chart; use Tools|Options; open Chart tab; set how to Plot Empty
cells
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Just Joe" <Just wrote in message
...
I used to know this but got new software. If I leave a blank in a line of
data and at the end of the data, the graph line drops to zero. I just
want
it to igore blank spaces.