I have a bar chart and I have written a macro to set the scroll bar right when you open the report. Its working as desired. But when you change the cyclic group from Period to Week or date, the scroll bar seems to set at some default location , but not towards the right.
/*********************************************/
Sub SetScrollRight
set chart1 = ActiveDocument.GetSheetObject("CH42")
set p1 = chart1.GetProperties
p1.ChartProperties.XScrollInitRight = true
chart1.SetProperties p1
End sub
/*********************************************/
Can some one please explain how to achieve this macro even for cyclic group?
Thanks,
Karthick