Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
trendline error
Hello, need help. I created trendlines in excel using polynomial curves. They look pretty good, but the equations supplied are way off. Can somebody help me. Using a second order poly gave the best results but still way off. thanks. -- jlsexcel ------------------------------------------------------------------------ jlsexcel's Profile: http://www.excelforum.com/member.php...o&userid=30169 View this thread: http://www.excelforum.com/showthread...hreadid=498527 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
trendline error
jlsexcel -
Perhaps you need to display more significant digits. One way is to click the trendline equation to select it and then press the Increase Decimal button repeatedly. - Mike www.mikemiddleton.com "jlsexcel" wrote in message ... Hello, need help. I created trendlines in excel using polynomial curves. They look pretty good, but the equations supplied are way off. Can somebody help me. Using a second order poly gave the best results but still way off. thanks. -- jlsexcel ------------------------------------------------------------------------ jlsexcel's Profile: http://www.excelforum.com/member.php...o&userid=30169 View this thread: http://www.excelforum.com/showthread...hreadid=498527 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
trendline error
see my Excel Tips on the use of LINEST for polynomial fit -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "jlsexcel" wrote in message ... Hello, need help. I created trendlines in excel using polynomial curves. They look pretty good, but the equations supplied are way off. Can somebody help me. Using a second order poly gave the best results but still way off. thanks. -- jlsexcel ------------------------------------------------------------------------ jlsexcel's Profile: http://www.excelforum.com/member.php...o&userid=30169 View this thread: http://www.excelforum.com/showthread...hreadid=498527 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
trendline error
You can only fit a polynomial trendline to an X-Y scattergraph. They really
should incorporate an error message when you try to fit it to any other type of graph. Hope this helps. P. Williams "jlsexcel" wrote: Hello, need help. I created trendlines in excel using polynomial curves. They look pretty good, but the equations supplied are way off. Can somebody help me. Using a second order poly gave the best results but still way off. thanks. -- jlsexcel ------------------------------------------------------------------------ jlsexcel's Profile: http://www.excelforum.com/member.php...o&userid=30169 View this thread: http://www.excelforum.com/showthread...hreadid=498527 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trendline covering up error bars | Charts and Charting in Excel | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Trendline error??? | Charts and Charting in Excel |