how do I extend a trendline to cut x & y axis in excel

M

msterling

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
 
J

Jerry W. Lewis

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
 
Top