View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton
 
Posts: n/a
Default Logarithmic curve formulas in charts and LOGEST fx values?

Rich -

I am trying to calculate values for a curve using the LOGEST fx, but the
numbers are not agreeing with the formula provided by the logarithmic
curve formulas in a chart of the data (nor by the 'eyeball' method). Any
thoughts? <


Two thoughts:

(1) LOGEST is appropriate for an exponential trendline, not for the
logarithmic trendline.

(2) Be sure you're using an XY (Scatter) chart type, not a Line chart type.

- Mike
www.mikemiddleton.com