| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Solver vs. Exponential Trendline | Excel Discussion (Misc queries) | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
| Trendline Extract | Charts and Charting in Excel | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| How do I get the trendline equation from Excel to script? | Charts and Charting in Excel | |||
Hybrid Mode
