View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?