View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default Getting the values from a logarithmic trendline

Unclear what you mean by "the end"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Garf" wrote in message
...
I would like to put the end logarithmic trendline value on my chart and am
struggling with the linest function my data set looks like this

01jan09 20
02jan09 60
03jan09 113
04jan09 125
05jan09 127
06jan09 129

and so on

I have applied a logarithmic trendine and as i said would like to display
the end value, my charts equation is y=43.972Ln(x + 41.641, im a little
new
to this so if anybody can help i would appreciate it