my problem is the following (didn't find info how to do it in the official documentation) - recorded ~108k ping results to LibreOffice table with columns

  • DATE (letter A),
  • LATENCY (letter B),
  • STATUS (letter C).

Some rows contain empty cells for LATENCY (requests timed out for echoes waited 3000ms or more), that's why I managed to mark them with RED background color in Conditional formatting and then created an "Area" type chart with date/latency as X/Y values.

How to edit the chart so those empty cells are shown as RED vertical lines (3000ms long RED lines) in the same chart? You can see the current chart in the attached image.

Link to the SPREADSHEET file

enter image description here

  • Maybe use a helper column with a formula (IF(B2="",3000,0)). Then use a stacked bar chart and a separate series for those values? Jan 28 at 19:06
  • Can you provide an example, I'll attach the spreadsheet file in the original post
    – 1000Gbps
    Jan 30 at 14:14


You must log in to answer this question.

Browse other questions tagged .