Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to fix the initial scroll bar position to far right in any chart

Default position of scroll bar will be left in any chart, pls suggest me how i can fix the position of scroll bar to the far right of the chart as its position whenever i open the appilcation.

3 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Are you able to reverse the x-axis sort order instead?

Not applicable
Author

That is not a problem, But i need the position of scroll bar to be in rtight.Thanks

Jason_Michaelides
Luminary Alumni
Luminary Alumni

I found this in the APIGuide.qvw:

rem Preserves scroll position in scrollbars

set mybox = ActiveDocument.GetSheetObject("LB01")

set mbp = mybox.GetProperties

mbp.Layout.Frame.PreserveScrollPosition = true

mybox.SetProperties mbp

Don't know if it'll work with chart scroll bars but maybe worth a try...