X-axis : Cyclic group for data as ( Date, week, period)
Y-axis : Country Dimension
Measure : Sales.
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.
Could any one suggest on this?
/*********************************************/
Sub SetScrollRight
set chart1 = ActiveDocument.GetSheetObject("CH42")
