Level 1 (0 points)
I was wondering how to make a trend line go through the origin (0,0)? I see the option to select endpoints but the program wont let me select an endpoint.

Mac Book Pro, Mac OS X (10.5.8)
• Level 7 (29,960 points)
I may be missing you point, but do you have a data point at 0,0, and is there any reason to expect that the estimate should pass through 0,0? If yes to both, then you might consider using a polynomial fit. Keep raising the order of the polynomial until the line comes as close to your actual data point as you want, but beware that higher orders can create pretty bizarre curves that probably don't represent reality.

Jerry
• Level 1 (0 points)
I dont have a point at the origin, but i want to extend the trendline so that it goes through (0,0). And the trendline has to be linear
• Level 7 (29,960 points)
You could add a second series, with a data point at 0,0, and call it a trend line. This would require that you calculate the slope yourself and use it to determine the location of the other end of the line.

Jerry
• Level 2 (335 points)
You cannot force a true trend line to go through zero - it can only do this if the source data enables it to go through zero. The only way would be to add numerous false data points at 0,0 to bias the trend. Not very scientific!
• Level 6 (11,615 points)