Do not chart errors

[PIJim]

I have a formula which returns "" if there is an error.

The "" shows as zero on my line chart. I have selected "show empty cells as gaps" in the 'select cells" radio button.

If I remove the ISERROR function, the error values do not show as zero but there is a line between the data points before and after.
I want to show them as gaps.

My formula:
=IF(ISERROR(VLOOKUP(+D1297&" - "&$A1298,'monthly raw data'!$D$1:$L$10000,VLOOKUP($B1298,Sheet1!$A$1:$B$10000,2,FALSE),FALSE)),"",VLOOKUP(+D1297&" - "&$A1298,'monthly raw data'!$D$1:$L$10000,VLOOKUP($B1298,Sheet1!$A$1:$B$10000,2,FALSE),FALSE))

Thanks for any help
Jim

 

[njimack]

Rather than returning "", amend your formula to return NA()

 

[PIJim]

I tried that but the line chart still shows lines where I want gaps.
The only place it doesn't show on the chart is if there aren't and data points with values after the NA() cell. If there are numerical values before and after the NA(), the line goes through the NA() data point.
I want this to show as a gap in the chart.

thanks,
Jim