how do i make an xy graph start at 0 instead of at 1?

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

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

In article <96E0932F-2F45-4FAD-922E-E4C1F0B447E6@microsoft.com>,
NeoDS@discussions.microsoft.com says...
> 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??
>

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/
_______


"NeoDS" <NeoDS@discussions.microsoft.com> wrote in message
news:96E0932F-2F45-4FAD-922E-E4C1F0B447E6@microsoft.com...
>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??

When you add the trendline, specify intercept at 0
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"NeoDS" <NeoDS@discussions.microsoft.com> wrote in message
news:96E0932F-2F45-4FAD-922E-E4C1F0B447E6@microsoft.com...
>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??

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.

"NeoDS" wrote:

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

> thank you for you help, but i need the trend line to be a curve, and when i
do
> that it won't let me to set the intercept.
>
> "NeoDS" wrote:
>
> > 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??

What form of curve do you need for your trendline?

I made it!
hehe
It is very simple. Today I accidently klicked POSITION AXIS: ON TICK MARKS (at primary axis options)

I'm using MS office word 2007 but maybe this is solution for excel too.

best wishes!