I have an libreoffice-calc spreadsheet with some results of daily measurements. Some days are missed for some reasons.
I want to create a graph showing this data, and I want to highlight all missed data parts. E.g. use solid line to connect existing data points and dotted line to connect through missing data points, or using different colors for that.
Example of what I want:
In this question I found a way to connect missing data points - but how to highlight those connections? Setting "Format Data Series" -> "Plot options" -> "Continue line" option makes all graph solid, so you can't assume which parts of graph are showing existing or missing data.