Right click a data point in the chart & Select "Add Trendline" Highlight cells A2:B5, select Insert>Chart (or use toolbar Chart button)Ĭhart Type: XY (Scatter), click Finish (or Next, Next, Next) Open the attachment and/or replicate the problem: I am using Excel 2003 but the same thing happened under a newer version (my son's Excel 2010, and apparently 2012) He also showed it to his professor (not sure what one) and (quote from email) "she was able to replicate the exact same problem we were having, and had no idea what was happening." This problem has stumped me (no surprise) & stumped my son (surprise, he is finishing his last year as a business major & has good experience with Excel). Excel calculated Polynomial formula does not match data, why?
0 kommentar(er)
