Oh. Excel 2007? ISTR an issue like this when calculating a trendline using
all negative values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Marco Couch" wrote in message
...
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.

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Marco Couch" <Marco wrote in message
...
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.