Extracting coefficients from a trendline

[Hleighm1212]

Hi all,

Here's my situation....

I have a chart with 3 series on it, 'low',' high', and 'combo'. Each of these series pulls from several columns, and not the same rows. So low might be A1-B7, C3-D4, and high might be A1-B14, E2-F5.

In the future, I may have to add or change data in these columns, and i may need to update the series to include new columns. My graphs are log-log, and I have power (y=ax^n) trendlines for each seriea. I have the formulas and R2s shown.

I need the a, n, and R2 values for each series, and i need them to update as the series changes. Ideally, I'd also like the x range of each series, but I can just manually look it up. This seems easy enough to just copy and paste, but I have to do it a few hundred times, and, as I said, the values may be updated.

I've read a couple posts suggesting linest, but i think as complicated as my series are, and the fact that they'll change, maybe that wouldn't work well.



Thanks in advance !