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: [email protected] 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
