|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 15th, 2009, 06:02 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
How do I stop trendline from touching the y-axis?
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. 
|
|
#2
February 15th, 2009, 06:19 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I stop trendline from 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.
|
|
#3
February 15th, 2009, 06:24 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I stop trendline from 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.
|
|
#4
February 15th, 2009, 07:08 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I stop trendline from 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.
|
|
#5
February 15th, 2009, 09:28 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I stop trendline from 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.
|
|
#6
February 16th, 2009, 12:35 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I stop trendline from 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.
|
|
#7
February 16th, 2009, 11:18 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I stop trendline from 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.
|
|
#8
February 16th, 2009, 11:28 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I stop trendline from touching the y-axis?
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
