<div>
There are a number of ways, all under goodness of fit (which I forgot some decades back).<br />
<br />
The simplest way (if the numbers are positive and you have a good regression line) is to calculate the y value on the line for the x value of the point. <br />
<br />
The vertical distance between the line is y(line) - y(point). <br />
<br />
That is one way and that is not the only way.
</div>


There are a number of ways, all under goodness of fit (which I forgot some decades back).

The simplest way (if the numbers are positive and you have a good regression line) is to calculate the y value on the line for the x value of the point.

The vertical distance between the line is y(line) - y(point).

That is one way and that is not the only way.

EE-TRENDexample.jpg

EE-TrendExample.xlsx

<div>
<div class="content wysiwyg-content">
How do I calculate the distance from a linear trend in a line chart that goes up and down but steadily increasing?
</div>
</div>


How do I calculate the distance from a linear trend in a line chart that goes up and down but steadily increasing?

Distance from linear trend

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.