Excel Charts - Auto Scaling the Y Axis

Question

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

sergeibaklan · Answer

Stoddardv&nbsp;
Do you mean that Auto doesn't work in your case?

stoddardv · Answer

SergeiBaklan&nbsp;Hi Sergei:&nbsp;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&nbsp;&nbsp;&nbsp;And&nbsp;&nbsp;I cannot find any "Auto" setting like you dispelled in your screenshot...&nbsp;Any ideas?&nbsp;Thanks....