Extracting coefficients from a trendline

Hleighm1212

New Member
Joined
Sep 24, 2020
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
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 !
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,118,358
Messages
5,571,706
Members
412,413
Latest member
dvprajapati
Top