Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Charts Common Problems > Exponential Trendline< Previous | Next > 

 

What is an Exponential Trendline ?

 

 

Equation: y = c *e ^(b * x)

 
 

c: =EXP(INDEX(LINEST(LN(y),x),1,2))

 
 

b: =INDEX(LINEST(LN(y),x),1)

 



 

Adding a Trendline

 
   


 

Trendline Options

 
   


 

Things to Remember

 



 Copyright © 2010 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >