Changing angle of trend line.
 

How do I set a trend line not as an average through my points but as a slope
that I have determined?

Changing angle of trend line.
 

Draw it yourself. If you know the endpoints, put their coordinates into a
few cells:

X1 Y1
X2 Y2

Copy this range, select the chart, use Paste Special to add the data as a
new series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"smrtie17" wrote in message
...
How do I set a trend line not as an average through my points but as a
slope
that I have determined?

Changing angle of trend line.
 

Jon has already shown you how to draw a straight line. Though, I am not sure
why you would call it a trendline. After all, a trendline with a slope that
you determine is not a trendline!
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"smrtie17" wrote:

How do I set a trend line not as an average through my points but as a slope
that I have determined?