Force scale to start at zero
 

I am using Excel 2007 to display an X-Y graph and I want to force the Y
scale to start at zero. How can I do that?

Force scale to start at zero
 

On Wed, 1 Jul 2009 09:08:41 -0500, Michael Dobony wrote:

I am using Excel 2007 to display an X-Y graph and I want to force the Y
scale to start at zero. How can I do that?

I found it.

Force scale to start at zero
 

Hi,

The easiest way is to right-click the trendline and choose Format Trendline,
on the Trendline Options tab check Set Intercept and enter 0.

I have heard rumors that this feature does not always perform correctly
either here or in the LINEST function of the spreadsheet, so keep your eyes
open.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Michael Dobony" wrote:

I am using Excel 2007 to display an X-Y graph and I want to force the Y
scale to start at zero. How can I do that?