Trendline data points

  • Thread starter Thread starter rekoop
  • Start date Start date
R

rekoop

Is is possible to display the data points (ie. the actual
numbers) on a trendline?

Thank-you
 
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:

http://www.stfx.ca/people/bliengme/ExcelTips/Polynomial.htm

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