#### wrecclesham

##### New Member

- Joined
- Jul 24, 2019

- Messages
- 45

I have a formula in a table that uses an IF function. The output of the formula dynamically plots a line chart.

The problem I'm experiencing is that if the output of the IF function is False, then the "" value output is interpreted by the dynamic line chart as a zero instead of a blank cell, and a line is plotted at 0.

What is supposed to happen is that nothing should be plotted at all where the formula outputs "".

How can my formula output a blank cell output in such a way as to prevent the corresponding dynamic line chart from treating it as a "0" and plotting a line through zero?

The problem I'm experiencing is that if the output of the IF function is False, then the "" value output is interpreted by the dynamic line chart as a zero instead of a blank cell, and a line is plotted at 0.

What is supposed to happen is that nothing should be plotted at all where the formula outputs "".

How can my formula output a blank cell output in such a way as to prevent the corresponding dynamic line chart from treating it as a "0" and plotting a line through zero?

Last edited: