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. |
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. |
All times are GMT +1. The time now is 09:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com