View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default Can I obtain x values from y values on an Excel chart?

if Y=A*Exp(BX); then Ln(Y) - Ln(A) = BX or X= (Ln(Y) -Ln(A))/B

Also remember you can use LOGEST or LINEST to extract the trendline
coefficients into cells rather than copying them form equation on chart; see
http://www.stfx.ca/people/bliengme/E...&%20LOGEST.htm
http://www.stfx.ca/people/bliengme/E...Polynomial.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Helen" wrote in message
...
I've constructed an exponential curve, is there a function whereby I can
enter new y values to obtain the corresponding x values, instead of having
to
print it off and read off manually?

Many thanks from a novice

-Helen Moore