Set x-axis scroll position to a specific dimension value
I am trying to find a way to set an x-axis scroll position to start at a certain dimension value. I don't want to change the sort order, or set a dimension axis static min (which removes the scroll).
For example, if my bar chart object is plotting a dimension of values 1-10, sorted by dimension in ascending numerical order (1-10), and I have the Max Visible option set to 5 and showing the x-axis scroll bar, then how can I set the scroll position to start at dimension value 6 instead of 1? (while keeping the option of scrolling back to 1 if the user desires).
Does anyone have a solution for this? I would appreciate any ideas. Thanks!