Let say I have a chart ascending by week, and I only want to show the last 12 weeks by default. I know I can do this by using the Max Shown, Show Scrollbar and Reversed properties in the chart. My issue is the Reversed option will only scroll to the end on document open. So if I filter by some other field and this filter affects the chart, the scroll bar will no longer be at the end. I understand you could probably write a macro and assign it, but I am not sure where/how to most efficiently do this since I haven't had much exposure to the API.
I am just wondering if there is some efficient way to force these scrollbars to always be at the end (unless moved by the user)??
Thanks in advance for your help.