View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Robert11 Robert11 is offline
external usenet poster
 
Posts: 30
Default Trendline Question

Hello,

I have a chart from a simple data set that plots a new point each day.
It's my blood p vs date.

I also have it show on the chart a "Trendline" linear fit, which I guess is
the rms of the data points.

Works just fine.

Question: Is it possible to have the Trendlinebe computed for, and show on
the chart for, Only
a particular range of dates in the data, rather than the for the whole data
set ?

e.g., if my data goes from Sept, 2006 to the present, can i just have the
Trendline show for the Jan 2007 to the present data points ?

How, please ?

Thanks,
Bob