How remove line dropoff in chart?

In the file below. I have a average line that drops off when it moves into the following day.

I have a formula which should default the cell to NA,But it goes to #DIV

I just cant remove the drop
anyone know how to solve this?

There are no formulae in the file you attached - what formula are you using at the moment?

F4 copied down:
=IFERROR(AVERAGEIF(C4:E4,">0"),NA())
?

chart drop off

p45cal said:

F4 copied down:
=IFERROR(AVERAGEIF(C4:E4,">0"),NA())
?

Click to expand...

Yes , sorry here is the file. NA is showing , can't figure out how to remove drop in chart.

Still no formulae in the file and, by the way #DIV/0! is showing (not NA) but it's just text in a cell.
What formula are you using yourself?
Did you try my formula?
Do you have macros in your actual file?
What version of Excel are you using?

I can get rid of the 'drop-off' but I need to know we're on the same page.

If you can get NA to show in that cell as a result of a formula, all you may need to do is change the chart type of that yellow series from
Stacked line with markers
to
Line with markers.