Hello All. I'm using Excel 2016
I have a simple time series XY chart of closing stock prices. To scroll through the data, rather than create a dynamic chart using range names, I am alternatively trying to do so by changing the X axis range [ eg. Series 1 on the chart is daily data which begins Jan 1 1970 and extends to Jan 1 2018, however to zoom in on the most recent 2 years I set the X range start point to Jan 1 2016 and end point to Jan 1 2018]. this works well, however I would like to control the Y axis scaling as excel will often use Zero as the minimum value. In my example of the 2 year period, I am unable to simply take the Min of series 1 as it extends back to 1970 and would provide the wrong value [ I need the min for the past two years ].
I was wondering if there was a way to determine the range of what is actually shown on the chart rather than the entire Series - and if so, I could take the Min of that range... or if there is some other way?
Thanks again..
Bookmarks