Skipping cells that have formula returning blank in a plot

Excel 2016

I am trying to plot a chart that finds the end of populated cells.
The problem I am facing is that since all my cells (SETUP.chartTOPICS columns A and B) are all populated with a formula to update when Database column E is updated.
I created a chart using a definedName using offset so it also continues to update.
You see the resulting plot has a lot of empty entries, I'd like it to dynamically change the range based on the column entries.

Is this possible?

Originally Posted by FDibbins

Structure the formulas so they return an error instead if a blank. Charts ignore error cells.

I tried using NA() in the value if false entry, but my plot still includes #N/A.
Can you provide an example?

Originally Posted by kryssie.e

I tried using NA() in the value if false entry, but my plot still includes #N/A.
Can you provide an example?

I changed the named range definition and now it works.

FROM: =OFFSET(SETUP.chartTOPICS!$A$4,0,0,COUNTA(SETUP.chartTOPICS!$A$4:$A$1000))
TO: =OFFSET(SETUP.chartTOPICS!$A$4,0,0,COUNTIF(SETUP.chartTOPICS!$A$4:$A$1000,"<>#N/A"))