To elaborate on Jerry's response, you can create one or more trendlines for each
series in a chart (as long as the chart type supports a trendline). Every point in
the series is included in the calculated trendline. If you want to compute a
trendline for only part of a series, you need to add a series that includes only the
points you're interested in, and make a trendline for the added series.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.