Excel Line Chart Range: Adjust TOTAL Range?

[JReeves_21]

Preface: I have searched and tried numerous things. I have a feeling this is going to be a super simple fix that I am just missing. Thanks in advance. I made an account here JUST for this question... lol.


I'm logging data for a clients weight loss and after a certain number of data inputs it increases the range so far that the "Progress Graph" looks like a straight line.


If I reduce the number of inputs, it lessens the the range.

Starting weight was 218 and current weight is 178. Her goal is 160.

It shows a range from 0 to 250 lbs.

My question is: How do I adjust the TOTAL range for the entire chart down to say 225 to 150?

 

[AlphaFrog]

Double-click on any number on the y-axis
Select the Scale tab on the Format Axis pop-up context menu
Set your min and max scale to suit.

 

[JReeves_21]

Thank you, sir.

I knew it was something simple I was overlooking.