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
 
Back
Top