Excel Charts - Auto Scaling the Y Axis

[Stoddardv]

Simple question using Excel 365. Have a simple worksheet which retrieves daily stock price data for a particular stock (using STOCKHISTORY) and then charts it with a simple line chart. If I choose MSFT, the correct chart is displayed. The Y Axis ranges from 200$ to 400$. 

Then I repeat but using AAPL. But now the Y axis does not change. Since AAPL stock for the last year ranges from 100 to 225, the price line is not displayed - just the bit where there price is > 200. 

So every time I select a different stock I have manually edit the scale of the Y axis. 

How can I avoid having to manually adjust the Y axis?

Thanks for any ideas

[#2]

@Stoddardv 

Do you mean that Auto doesn't work in your case?

[#3]

@Sergei Baklan 

Hi Sergei:

From your screenshot it looks like you are using Excel for Windows. I am using Excel 365 on a Mac. Here is what I see for Axis Options 

And 

I cannot find any "Auto" setting like you dispelled in your screenshot...

Any ideas?

Thanks....

[#4]

@Stoddardv 

Sorry, I'm not on Mac. Perhaps @Riny_van_Eekelen could clarify how it works on Mac.

[#5]

@Stoddardv On a Mac the "Auto" setting is represented by the 'rounded arrow'.

Press that one and the bounds will reset to automatic.

[#6]

Bingo - you are right... I assumed that that symbol meant "undo". But I just tried it and it does that I want. Thanks for you both in helping me.

[#7]

@Stoddardv I guess you can call it undo. That is, undo the manual adjustment :)