N
NeoDS
I made a scatter graph, with the origin value at 0. when i made a line of
best fit, the line starts and 1. how do i make it start at 0??
best fit, the line starts and 1. how do i make it start at 0??
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tushar Mehta
I will assume that "made a line of best fit" means you added a
trendline. If so, double-click the trendline. In the resulting dialog
box, from the Options tab, check 'Set Intercept to' and enter zero in
the adjacent textbox.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
trendline. If so, double-click the trendline. In the resulting dialog
box, from the Options tab, check 'Set Intercept to' and enter zero in
the adjacent textbox.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
J
Jon Peltier
If your first X value is at 1, double click the trendline, and on the
Options tab, in the Forecast box, change backwards to 1.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Options tab, in the Forecast box, change backwards to 1.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
B
Bernard Liengme
When you add the trendline, specify intercept at 0
N
NeoDS
thank you for you help, but i need the trend line to be a cuve, and when i do
that it won't let me to set the intercept.
that it won't let me to set the intercept.
N
NeoDS
thank you for you help, but i need the trend line to be a curve, and when i
do
do
M
MrShorty
What form of curve do you need for your trendline