Macro to Scroll a bar chart to its right

[#1]

Hi,

Do we have a macro to scroll the scroll bar position to the right most corner?

I have created a Qlikview report with a bar chart which will be exported as an image every month automatically. But, once each month's data gets added, I need the scroll bar position to be at the rightmost point (in order to accommodate the newly added month).

It would be handy to have a macro script which can do that. Can any one please help me out.

Regards,

Mithun

[ashfaq_haseeb]

Hi,

Check if this help

Sub SetScrollRight
 set chart1 = ActiveDocument.GetSheetObject("CH06")
 set p1 = chart1.GetProperties
 p1.ChartProperties.XScrollInitRight = true
 chart1.SetProperties p1
End sub

Regards

ASHFAQ

[#3]

Hi Ashfaq,

Thank you for your reply! I have already tried this command, but without success.

The scroll bar does not change its position. PFA my test document.

Regards,

Mithun

[ashfaq_haseeb]

Hi,

Its working as expected.

Have a look at attached alternate solution without macro.

Regards

ASHFAQ