error #N/D! in chart

[john_cash]

hello all
how to hide error #N/D! in table and chart?
Thanks you
john

[jomaor1]

Hi,

First of All, you 'should' change your Formula on B2 like this:

Please Login or Register  to view this content.

And remove the "NA()" ONLY FOR THE LEGEND. Change it to some text...

Second, select your Chart and go to Design>Select Data>Hidden and Empty Cells> and Mark "Show #N/A as an empty cell"

Cheers!

[john_cash]

Hello jomaor1
I do not understand

the formula (array) is already:

Please Login or Register  to view this content.

Second, select your Chart and go to Design>Select Data>Hidden and Empty Cells> and Mark "Show #N/A as an empty cell" <<< ???

[jomaor1]

Hi,

So I didn't manage to hide your legend by using normal Excel Tools, but I was able to create using a simple code.

So basically everytime you Enter the tab "Grafici" it will Update your 'table' to only show values, and hide Errors.
It's a simple solution, not the right one, but the one I could do for you

[john_cash]

I jamaor1
I don't see any change you always see #N/D!

[jomaor1]

Hi John!

First of all, did you enable the macros when you enter the Workbook? It appears in a yellow alert on the top of the Screen.

And can you tell me what your "NA()" formula returns? I suppose it returns something in Italian like "#N/D" or "#N/E"

And if you want to change it, you can press "Alt+F11" and edit the code on your "Grafici" sheet.

[john_cash]

I attach 2 screenshots

[jomaor1]

Aha!

I knew it wasn't #N/A.

Please follow the attachment. Just click on another tab, and click back on Grafici.

[john_cash]

I don't understand how to proceed, I always see # N / D

[jomaor1]

Hi,

My guess is that "VBA Macros" aren't enable, or doesn't exist on your Excel Version. Because my file works perfectly for me,
Everytime you change the tab, it automatically filters OUT the "#N/D".

So if you can't use VBA Macros, I don't know how to do it, sorry.

[john_cash]

I do not know what to say...
Anyway thank you anyway.
A greeting
john