ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Exponential trendline offset (https://www.excelbanter.com/charts-charting-excel/66521-exponential-trendline-offset.html)

drjulianof

Exponential trendline offset
 

I have set the normal exponential trendline to a scatterchart but have
to add an offset to the equation (instead of y = a * e^bx, I would like
to use y=(a*e^bx) + c.

How can I do that in Excel?

Thanks in advance.

Juliano Fernandes


--
drjulianof
------------------------------------------------------------------------
drjulianof's Profile: http://www.excelforum.com/member.php...o&userid=30685
View this thread: http://www.excelforum.com/showthread...hreadid=503477


Bernard Liengme

Exponential trendline offset
 
If I want to fit to y=(a*e^bx) + c, I would use Solver
If interested sent message to my private email with sample data and I will
show you how
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"drjulianof" wrote
in message ...

I have set the normal exponential trendline to a scatterchart but have
to add an offset to the equation (instead of y = a * e^bx, I would like
to use y=(a*e^bx) + c.

How can I do that in Excel?

Thanks in advance.

Juliano Fernandes


--
drjulianof
------------------------------------------------------------------------
drjulianof's Profile:
http://www.excelforum.com/member.php...o&userid=30685
View this thread: http://www.excelforum.com/showthread...hreadid=503477





All times are GMT +1. The time now is 06:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com