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?