Trendline using #N/A instead of zeros not working

[EKinATX]

Hello,

I'm trying to use a trendline for a one month period (daily on X axis), where I show actual vs forecast data. The trendline is for the actual data, which shows 1 week in the total month.

I'm using #N/A to replace zeros, however the trendline is still treating the #N/A as a zero.. Any help is appreciated.

Thanks