Trendline Equations

[Steve Morris]

Having produced a trendline and have the equation displayed on the chart,
is there any way of displaying that equation on the excel sheet itself. I
need to have the chart hidden yet require the equation to update different
inputs.

 

[Tushar Mehta]

I have posted an enhanced version of code originally posted by David
Braden. See the google.com archive at
http://groups.google.com/group/microsoft.public.excel.charting/msg/0eda
30f29434786d?hl=en&

For an alternative approach see
Trendline coefficients
http://www.tushar-mehta.com/excel/tips/trendline_coefficients.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions