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.

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" <(E-Mail Removed)> wrote in message
news:E11B182F-B1E5-4035-AA9A-(E-Mail Removed)...
>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.

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" <(E-Mail Removed)> wrote in message
> news:E11B182F-B1E5-4035-AA9A-(E-Mail Removed)...
> >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.
>
>
>