Office Excel Linear Approximation is Inaccurate
listed in answer
ANSWER:
You have created a line chart where the X values are being treated as labels, not values, and when you add the trend line it is using the label positions for X values. To get the correct behavior, change the chart type to XY scatter plot.
by Mike Fitzpatrick from http://superuser.com/questions/423800
New Comments