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

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.
 
J

Jon Peltier

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
 
B

Bernard Liengme

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
 
M

Marco Couch

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.
 
J

Jon Peltier

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

Top