Forum Discussion
Solved
Accessing Chart Linear Trendline slope (m) and intercept (b) values
This is somewhat similar to another request - but I'm new to this, and got a little lost within the search system. I have several charts with linear trendlines - the trendline neatly shows y=mx +b o...
Many thanks for your very prompt reply.
I probably should have done more research first - I have now tried using LINEST - and got the cell data ok - the only thing I noticed, was that LINEST gave a VALUE! fault, if there were gaps in the data range. The TRENDLINE on the chart seemed to handle gaps perfectly well.
I'll try your suggested intercept and slope methods, and see how I go. The results from these may work better for my data column layout - with regard to relative referencing (write once, drag for each column).
Many thanks!