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?
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?
