If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trend lines in charts under Excel
Something I have discovered for long but which continues with Excel
2007 (under XP): when you draw a trend line in a scatter or line chart I generally get either not the best fit (or equation) and/or almost sytematically the wrong equation associated to this trend line. Has anybody seen that already and moreover knows why it is like that? Surprising from a company like Micosoft. |
#2
|
|||
|
|||
Trend lines in charts under Excel
cloclo -
Please provide an example. In my experience, Excel trend line provides best fit for a linear function in an XY (Scatter) chart type. For non-linear functions, the trend line is based on transforms of the original data, and often you could obtain a better fit using Solver to search for function parameter values. For a Line chart type, the trend line uses 1,2,3,... for the X values of the fitted equation, ignoring any numerical values you may be using as labels for the horizontal axis. - Mike http://www.MikeMiddleton.com "cloclo" wrote in message ... Something I have discovered for long but which continues with Excel 2007 (under XP): when you draw a trend line in a scatter or line chart I generally get either not the best fit (or equation) and/or almost sytematically the wrong equation associated to this trend line. Has anybody seen that already and moreover knows why it is like that? Surprising from a company like Micosoft. |
Thread Tools | |
Display Modes | |
|
|