View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default Access to Chart Trendline Equations in VB

KMH wrote...
I would like to get the 3rd order polynomial coefficients for an X-Y
Chart trendline into VB so I can automatically run a calculation at a
extrapolated X value and record this in my spreadsheet. If I can not
get the coefficients directly to do the calculation myself, can I plug
in the X value and calculate the resultant would help.


See

http://groups.google.com/group/micro...440d271303e0d6