Force scale to start at zero

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

Shane Devenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
How to correct a #N/A in vlookup 1
Constant % on X axis 2
Open my default template when right click, select New MS Word doc within a folder 0
Logarithmic Scale for the X-Axis 1
Dynamic graph 0
why my 2nd series scale change? 7
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0

Top