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?