K
Kamehameha
Hi All,
I have had a look around similarish topics on the forum but not found the
answer I' looking for.
For example, I have Months in Cells A1:L1 and performance information in
cells A2:L2. I create a line chart to show the performance over the year and
then base a logarithmic trendline on the performance.
I would like to be able to analys the numbers that make up the trendline so
would like to know the formula Excel uses to create it so I could pop it in
cells A3:L3.
Is this possible? I'm not a maths guru whatsoever so I found some of the
Excel help files and some of the posts in the forums I've looked at a bit
over-my-head!
The above is an example, so not what I'm actually doing but the principal is
exactly the same.
Any help would be greatly appreciated.
Kind Regards,
Steve
I have had a look around similarish topics on the forum but not found the
answer I' looking for.
For example, I have Months in Cells A1:L1 and performance information in
cells A2:L2. I create a line chart to show the performance over the year and
then base a logarithmic trendline on the performance.
I would like to be able to analys the numbers that make up the trendline so
would like to know the formula Excel uses to create it so I could pop it in
cells A3:L3.
Is this possible? I'm not a maths guru whatsoever so I found some of the
Excel help files and some of the posts in the forums I've looked at a bit
over-my-head!
The above is an example, so not what I'm actually doing but the principal is
exactly the same.
Any help would be greatly appreciated.
Kind Regards,
Steve