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

[Guest]

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.

 

[Bernard Liengme]

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