Linking Chart Text Box to a Worksheet Cell

Hi,

I have added a text box to a line chart and the text is linked to that in cell A1 (=A1)

Sometimes the value in cell A1 is intentionally "n/a", the result of a formula.

However, when "n/a" appears in cell A1 the text box shows #VALUE.

Can someone please suggest how to change the link to A1 so that "n/a" appears in the chart text box if that's what's in A1?

Thanks!

How about this?

=IFNA(A1,"N/A")

or:

=IF(ISNA(A1),"N/A",A1)