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