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 MS...
Charting
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 06, 2023

Stoddardv 

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

  • Stoddardv's avatar
    Stoddardv
    Copper Contributor
    Nov 08, 2023

    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
      Nov 10, 2023

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

      Press that one and the bounds will reset to automatic.

      • Stoddardv's avatar
        Stoddardv
        Copper Contributor
        Nov 11, 2023
        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.

Resources