Forum Discussion
Charts Record "0" when a Formula is in a Cell
The referenced Data Column has a Formula that will return a "" to the cell when there is no value to calculate. So the cell appears EMPTY but the chart reads as a "ZERO". This only happens ...
As an alternative, make the formulas return NA() instead of "". By default, charts treat #N/A as empty: