A trendline is a best fit through a series of points, and as such has no
actual data points of its own. You can use LINEST to get the
coefficients into the worksheet, and calculate trendline Y values for X
values of interest. Bernard Liengme has hints for working with
polynomial regression and LINEST:
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______
Ask a Question
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.
