Link to home
Start Free TrialLog in
Avatar of fitaliano
fitalianoFlag for United States of America

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
Avatar of Robberbaron (robr)
Robberbaron (robr)
Flag of Australia image

an exponential curve is matching a mathematical function, http://en.wikipedia.org/wiki/Exponential_function

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.
ASKER CERTIFIED SOLUTION
Avatar of dlmille
dlmille
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial