fitaliano
asked on
Exponential Curve in Excel
How do I create an exponential curve in Excel on a chart where my x-axis represents my Risk (from 0 to 12) and my y-axis represents my Value (from 0 to 22).
I want to display an exponential curve with a Risk limit of 11 and a Benefit limit of 18.
See attached PowerPoint to visualize what I am trying to achieve
Sample.ppt
I want to display an exponential curve with a Risk limit of 11 and a Benefit limit of 18.
See attached PowerPoint to visualize what I am trying to achieve
Sample.ppt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
so not quite sure what you want.... a function that has a value of 0 when risk =0 and value of 22 when risk=12 ? so it depends upon how many levels of exponent you want. for the shape you want, you are looking for a 2rd order or higher. Ax+Bx*x + C x*x*x
if you have a series of values (ie one for each level of risk), you can fit a curve to it using the linear regression function within excel.