The diagrama does not want to correctly display the result of the function

Copper Contributor

Hello

 

The diagrama does not want to correctly display the result of the function " =IF(U:U="";"";U:U-$AI$3) ", diagrama "breaks" when it hits an empty cell created by the function. Is it possible to somehow write an empty cell so that the chart displays correctly.

 

Thanks

2 Replies
What if you change the formula to:
=IF(U:U="";NA();U:U-$AI$3)