I am using excel SLOPE and ANGLE function to calculate the angle of trendline given the data points. But it always shows very high angle (~88 degrees). And if I change my x axis coordinates to same as y axis , then it shows 45 degrees at maximum, irrespective of how steep the slope is.
But actual angle of trendline is somewhat near 26 degrees for the following data points, whereas excel shows it 88 degrees.
week price
1 5521.41
2 5579.73
3 5639.15
EXCEL formula used : =DEGREES(ATAN(SLOPE(y axis range, x axis range)))
Actual trendline of these data points in action and actual degrees
