Force scale to start at zero

  • Thread starter Thread starter Michael Dobony
  • Start date Start date
M

Michael Dobony

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?
 
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.
 
Back
Top