[libreoffice-users] calc charting issue

I have a small spreadsheet 5x12 elements and the numeric content data
is missing for some cells. Their contents are given as ND for No Data. I
want to chart these 5 rows and at first thought I'd just set them to
zero. The range on y-axis values is about from 5 to 15. But with zeros
the chart line takes a dive to the x-axis then back up. 

I think a better visualisation would be for the graph lines to be
discontinuous where no data exists, precluding zeroing or smoothing
over the gap (usually only one missing datum) I don't see a handy way
to do this, does someone with more experience see how? I'll read
instructions if pointed to them.

Thanks,

Dave

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy