Charts Scrollbar - Right Align in Qlikview Appln

[#1]

I want to right align all the charts alone in my Qlikview application. There are close to 10 charts which should have the scroll bars right aligned by default Is there any simplest way to do this other than writing a small piece of macro for all the charts repetitively.

[#2]

No other way I know but with a macro. Its only a once off job so no big problem.

sub OneOff

set chart = ActiveDocument.GetSheetObject("CH14")
set p = chart.GetProperties
p.ChartProperties.XScrollInitRight = true 
chart.SetProperties p

end sub

Regards,

Gordon

[#3]

Thanks Gordon, I was also planning for the same.

But since i am having close to 10 charts should i need to define the macro separately for each chart or is there any other workaround available for this.

[#4]

I would just copy and paste the code in the macro editor and change the chart ID.

Gordon