LINEAR REGRESSION:

Use the add Trendline feature selecting Logarithmic type and the including the R2 and ‘display equation on chart’ options. Set the Trendline name to custom and label it Log Reg. Line. Note that Excel gives the equation of the line as y = c(Ln(x) + b where b is the y-intercept and c is the coefficient of Ln(x). ................
................