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.
 
You must log in or register to reply here.

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
Add series to line graph 4
Constant % on X axis 2
why my 2nd series scale change? 7
how to produce a lin-log graph instead of log-lin graph? 2
Help needed with multi y-axis chart 1
scales of 1st and 2nd series 1
Logarithmic Scale for the X-Axis 1

Back
Top