How do I stop trendline from touching the y-axis?

  • Thread starter Thread starter Marco Couch
  • Start date Start date
M

Marco Couch

I have plotted a few points in a scatter graph and need to add a linear
trendline, however everytime I do, it extends the trendline to the Y-Axis,
which makes my plots unclear and very bunched up.
I want to be able to add a trendline without it touching the y-axis.
 
Does the leftmost point have an X value of zero? Did you choose the option
to force the fit to pass through the origin?

- Jon
 
Generally, trendlines extend from first to last data point
They can be made to go further using the 'forecast' feature of the trendline
What is your situation?
How about changing the x-axis scale so trendlines stops before y-axis?
best wishes
 
No I didn't choose for it to pass through the origin, and the leftmost point
is (-6.91, -3.46) the rightmost point is (-4.61, -1.16) all points in between
are in a perfectly straight line.
 
Oh. Excel 2007? ISTR an issue like this when calculating a trendline using
all negative values.

- Jon
 

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 to change axes settings after adding trendline? 2
Trendline - 2nd Y axis 6
remove "linear" from trendline legend entry 2
How do I plot a trendline that goes through a specified point? 2
Sr. Citizen Question On Adding A Trendline, Please ? 1
How do I put words as the Y axis values? 0
Trendline Issues 4
different color on scatter plot separated by a trendline 1

Back
Top