Is it an XY chart or a line chart? Best regression results come with XY
charts. To get a trendline for a part of the series, add another series to
the chart using just the points of interest.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Terry" wrote in message
...
We have a XY line chart with X scale by time.

We now would like to have a trendline with specific time period.
How do I make a trendline with only part of data are used?