Forum Discussion
Stoddardv
Nov 06, 2023Copper Contributor
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
Sort By
- StoddardvCopper Contributor
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_EekelenPlatinum Contributor
Stoddardv On a Mac the "Auto" setting is represented by the 'rounded arrow'.
Press that one and the bounds will reset to automatic.