change formula for trendline settings

K

karthikpoly

Hi I am Karthik. I wanted to know how to change the formula for the trendline
setting(power function) form the default cx^b to c*(x-e)^b. I am in urgent
need of it so if any would reply to this I would be very thankful to them.
Thanks in advance.
Regards,
Karthik.
 
J

Jon Peltier

Excel has no native way to accomplish this transformation. I suppose I would
try to hack something using Solver.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top