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