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. Press with left mouse button on the "plus" sign next to the chart.
  3. Press with left mouse button on arrow next to "Trendline".
  4. Press with left mouse button on "More Options..." to open the task pane.
  5. Press with left mouse button on radio button "Logarithmic".

How to display the logarithmic equation on the chart

  1. Doublepress with left mouse button on the trendline to open the settings pane.
  2. Press with left mouse button on the checkbox "Display Equation on chart".