View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jerry W. Lewis
 
Posts: n/a
Default how do I extend a trendline to cut x & y axis in excel

Left-click on the trendline and choose Format Trendline. On the Options tab
are parameters to extend ("Forecast") the trendline as far forward or
backward as you wish.

Jerry

"msterling" wrote:

How do I extend a trendline on a scatter graph in the chart feature of excel
so it cuts the x and y axis
Thanks very much