Author: Oscar Cronquist Article last updated on October 23, 2018

Excel lets you easily add a best-fit curved logarithmic trendline calculated based on the method of least squares.

How to build

  1. Select the chart.
  2. Click the "plus" sign next to the chart.
  3. Click arrow next to "Trendline".
  4. Click "More Options..." to open the task pane.
  5. Click radio button "Logarithmic".

How to display the logarithmic equation on the chart

  1. Doubleclick on the trendline to open the settings pane.
  2. Click the checkbox "Display Equation on chart".