Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
I would just copy and paste the code in the macro editor and change the chart ID.
Gordon