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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I stop trendline from touching the y-axis? 7
Trendline - 2nd Y axis 6
Extending a trendline to the y axis 3
How to change axes settings after adding trendline? 2
How do I put words as the Y axis values? 0
How do I extend the X-axis in Excel2007 3
Trendline Issues 4
Horizontal axis to the bottom 1

Back
Top