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

Horizontal axis to the bottom 1
why my 2nd series scale change? 7
Constant % on X axis 2
how to produce a lin-log graph instead of log-lin graph? 2
Logarithmic Scale for the X-Axis 1
How do I draw a semilog graph? 1
scales of 1st and 2nd series 1
Help needed with multi y-axis chart 1

Top