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

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