Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

259 views
Skip to first unread message

Couch@discussions.microsoft.com Marco Couch

unread,
Feb 15, 2009, 1:02:04 PM2/15/09
to
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.

Jon Peltier

unread,
Feb 15, 2009, 1:19:29 PM2/15/09
to
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 Co...@discussions.microsoft.com> wrote in message
news:810A2001-50D1-4B87...@microsoft.com...

Bernard Liengme

unread,
Feb 15, 2009, 1:24:32 PM2/15/09
to
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 Co...@discussions.microsoft.com> wrote in message
news:810A2001-50D1-4B87...@microsoft.com...

Kelly O'Day

unread,
Feb 15, 2009, 2:08:36 PM2/15/09
to
<Marco:

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

http://processtrends.com/toc_trend_analysis_with_Excel.htm#Interactive_Regression


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


"Marco Couch" <Marco Co...@discussions.microsoft.com> wrote in message
news:810A2001-50D1-4B87...@microsoft.com...

Marco Couch

unread,
Feb 15, 2009, 4:28:03 PM2/15/09
to
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

unread,
Feb 15, 2009, 7:35:52 PM2/15/09
to
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" <Marco...@discussions.microsoft.com> wrote in message
news:40410744-AAEF-4A31...@microsoft.com...

Marco Couch

unread,
Feb 16, 2009, 6:18:02 AM2/16/09
to
I don't understand... yes it's Excel 2007 but what's ISTR?

Andy Pope

unread,
Feb 16, 2009, 6:28:15 AM2/16/09
to
ISTR means, I Seem to Remember.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


"Marco Couch" <Marco...@discussions.microsoft.com> wrote in message

news:28E283EE-333C-4173...@microsoft.com...

0 new messages