How to change axes settings after adding trendline?

[Ms.P]

Before adding the trendline to my linear scatter plot, I set my Y axis to
range from the desired -7 to -5 scale. After adding the trendline, the axis
is changed to range from -7 to 0 which produces almost a flat line. How do I
display the trendline on the previous -7 to -5 scale?

 

[davebarbetta]

Double-click on the axis, the Format Axis dialog box should appear.
Then under the "Scale" tab of the Format Axis dialog box, you should
be able to set the maximum and minimum (to -5 and -7).

If that doesn't work, can you tell me what the equation for the
trendline is? (Double-click on the trendline, the Format Trendline
dialog box should appear. Under the Options tab, choose "Display
equation on chart")

 

[Shane Devenshire]

Hi,

I can't duplicate your problem in 2003 or 2007. If you are in 2003 are you
making sure you set both axis? If the Auto checkbox is checked the axis can
readjust.