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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"karthikpoly" wrote in message
...
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.