Hi -

I am creating a manpower report and updating learning curve charts for a
decision making tool through VBA. The issue I am having is the trend line
(Power) in the charts gives me the output I need but I cannot figure out how
to pull the values I want into the spreadsheet. I have tried a couple of
functions but have come up empty handed. The RSQ function is not multilinear.
Does anyone know the formula for a power trend line? For example out of 100
samples I get the following info:

y = 1.5326x0.0657
R2 = 0.5744

Thank you in advance for any asssistance.
Carrie

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200807/1