View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Trendline Question

Hi,

Yes but you will need to add another series to the chart that is just the
periods you want to put the trend line on.
This additional series can be formatted so that it does not appear. Set the
line and marker styles to none.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Robert11" wrote in message
...
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