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")


On Jan 31, 7:17*pm, Ms.P wrote:
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?