Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Logarithmic trendlines
Can someone please tell me how to display a log base 10 equation for a
logarithmic trendline in an excel chart |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Logarithmic trendlines
Multiply the coefficient of ln(x) by ln(10).
Alternatively, get the coefficients in the worksheet by selecting a 5 row by 2 column range and entering the array formula =LINEST(range-with-y-values,LOG10(range-with-x-values),TRUE,TRUE). To enter an array formula complete data entry with the CTRL+SHIFT+ENTER combination rather than just the ENTER or TAB key. -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "Reece Bradley" wrote: Can someone please tell me how to display a log base 10 equation for a logarithmic trendline in an excel chart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trendlines | Charts and Charting in Excel | |||
Trendlines | Charts and Charting in Excel | |||
Trendlines | Charts and Charting in Excel | |||
Logarithmic Trendlines in Excel | Charts and Charting in Excel | |||
Trendlines | Charts and Charting in Excel |