Making a linear fit pass through a specific point

[mariamonney]

Hey, I have a scatter graphic with several points and I need to get a linear trenline in order to get an equation out of it. Since it involves standard test conditions, I need to make that line pass through the point (1000,100). Is there any way to force the trendline to pass through this point? I know you can force it to pass through the origin for example, but I cant find anywhere that allows me to choose another point.