If you substitute 1, 2, 3 etc in column A, the values calculated in column J (and C) fit the chart trendline more closely, if not exactly. (To make matters worse, the "dates" in C28:C29 include times of day. ![]() Your LINEST formulas use the actual dates in column A they are the numeric values 41395, 41426, 41456 etc, which are not equidistant apart. The Line chart trendline uses 1, 2, 3 etc for the x-axis, which are equidistant apart, not your data. However, you are using a Line chart instead of an XY chart, and the trendline of a Line chart is known to be incorrect unless the x-axis values are 1, 2, 3, etc. And the resulting yellow line closely tracks the chart trendline. ![]() ![]() I'm struggling to understand what your concern is.įirst, with your formulas in column K, I do not get any errors if I copy J27:J28 and J29 and copy C27 into C28:C29.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |