Hiding #N/A on chart when series values are not dates

[gwguy]

Hello,

I am trying to hide #N/A values on charts when they are not dates.

It does work in this example:

Jan-24 15
Feb-24 50
Mar-24 45
#N/A #N/A
#N/A #N/A

It will only chart data till March. But for some reason if my data looks like this:

Apple 14
Grapes 10
Mangoes 14
#N/A #N/A
#N/A #N/A

It does not hide the #N/A

Is there a way to circumvent this?

 

[Cubist]

To hide #N/A on charts, you can try hiding the columns/rows that contain the errors.