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.
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:
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.
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.
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.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
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
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
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.