create trendline

[Krista]

I have a data series with some missing data. Those cells are blank. When I
create a trend line it reads the blank cells as zero. How can I get a true
trendline of the actual data entered, omitting the blank cells.

 

[Bernard Liengme]

Replace the blank cells with =NA() - these will display as #N/A
best wishes

 

[Krista]

Perfect - thank you

Replace the blank cells with =NA() - these will display as #N/A
best wishes