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!
Bookmarks