View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Krista
 
Posts: n/a
Default create trendline

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.