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

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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

<Marco:

Take a look at my Interactive Regression post at this link.

http://processtrends.com/toc_trend_a...e_Regr ession


D Kelly O'Day
http://processtrends.com




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

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.

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.

I don't understand... yes it's Excel 2007 but what's ISTR?

"Jon Peltier" wrote:

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.

ISTR means, I Seem to Remember.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Marco Couch" wrote in message
...
I don't understand... yes it's Excel 2007 but what's ISTR?

"Jon Peltier" wrote:

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.