Excel trendline

[Ron Nossaman]

> Yes.  First click on the trendline itself.  Then go to Format menu and click
> on "Selected Trendline", then go to the options tab and click "Display
> Equation on Chart".  It will show on the chart a quadratic equation like 
> y = -.036*x^2 + .0399*x + 3.065.  Or something like that.  Set up a column
> in your spreadsheet which inputs your x values (in this case perhaps a rib
> number) and it will calculate the trendline value (y) at each point.  If
> that's what you mean.
> 
> David Love

That's what I mean, except I wanted something that would 
update dynamically when anything in the Y data array changed, 
which changes the formula - but I got it now.
Ron N