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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Krista" <[email protected]> wrote in message
news:[email protected]...
>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.

[Krista]

Perfect - thank you

"Bernard Liengme" wrote:

> Replace the blank cells with =NA() - these will display as #N/A
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Krista" <[email protected]> wrote in message
> news:[email protected]...
> >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.
>
>
>