How to omit non-empty zero-result cells from chart

[UnionJack]

I have a chart showing daily measurements of certain values. Each row in the sheet records one day’s values. I’d like the chart to show values up to the present day but omit future values; some values are numeric, some the result of a formula. Formulae in future columns return a zero value because that day’s entries have not been recorded yet, so the chart shows future values as zero, with a sharp drop from the current day’s value, instead of omitting them.

The problem is that, even if I select Omit missing entries, from the Properties of a trace, some traces do omit them and some don’t. I can’t see any difference between those that do and those that don’t.

Is there a way to make the chart ignore zero values instead of missing values?

[LeroyG]

@UnionJack

the result of a formula

Maybe you must change your formula, so it gives "" instead of 0.
Edit your question, and share a reduced sample file. Thanks.

[Lupp]

Many series can well contain valid zero values. We shouldn’t try to exclude invalid data based on the values, but first of all not generate or import them. For data prepared using formulas an empty string is mostly an acceptable representation of “not valid”. From the logical point of view NA() is clearly better. Ranges for imported data should simply have empty (blank) cells where data are missing.

[UnionJack]

That was it. Thanks LeroyG.