# Log10 Trendline in Charts

#### Greg73

##### New Member
Does anybody know if it is possible to get Excel to calculate a logarithmic trendline in a chart using base 10 and not base e?

Last edited:

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### Cindy Ellis

##### MrExcel MVP
Hello, and Welcome to the Board!

As far as I know it's not possible. If you need the log10 trendline equation, your best bet would probably be to calculate the log10 of the x axis in a helper column, then use the slope and intercept worksheet functions to calculate the coefficients. The form of the equation would be Y = slope * log10x + intercept.

Hope that helps,
Cindy

#### pgc01

##### MrExcel MVP
Hi Greg
Welcome to the board

Isn't the trendline the same? I think it's only the coefficient of the logarithm in the equation that changes.

As you know if you divide the logarithms of any number in 2 different bases you get a constant. You can therefore replace the logarithm in a base by the logarithm in another base just by multiplying by that constant.

Ex. You display the trendline equation in the chart:

y = 675.489569563135 * ln(x) - 224.580147323782

We know that

ln(x) = ln(10) * log(x) = 2.30258509299405 * log(x)

Replacing, we get

y = 1555.37221334904 * log(x) - 224.580147323782

Is this what you want?

Remark: I used the names of the worksheet function, ln(x) for logarithm of x in base e and log(x) for logarithm of x in base 10.

#### Greg73

##### New Member
Thanks Cindy for confirming its probably not possible.

You are right pcg01, I could calculate the correction to make it log10 for use in calculations if i want to, but I was hoping for presentation purposes to have it appear as log10 on the chart.

Cheers.

#### pgc01

##### MrExcel MVP
You are right pcg01, I could calculate the correction to make it log10 for use in calculations if i want to, but I was hoping for presentation purposes to have it appear as log10 on the chart.

If you want to have it appear with Log on the chart why don't you just edit the equation?

In the example I presented the equation on the chart was

y=675.489569563135ln(x)-224.580147323782

and you'd replace it with

y=1555.37221334904Log(x)-224.580147323782

Isn't this what you want?

Replies
4
Views
285
Replies
17
Views
2K
Replies
4
Views
149
Replies
1
Views
212
Replies
2
Views
169

1,181,580
Messages
5,930,718
Members
436,757
Latest member
Marijn

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back