Forum Discussion

Stoddardv's avatar
Stoddardv
Copper Contributor
Nov 06, 2023

Excel Charts - Auto Scaling the Y Axis

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

 

 

6 Replies

    • Stoddardv's avatar
      Stoddardv
      Copper Contributor

      SergeiBaklan 

      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....

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor

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

        Press that one and the bounds will reset to automatic.

Resources