Hello Experts,
I have a bar chart
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")
set p1 = chart1.GetProperties
p1.ChartProperties.XScrollInitRight = true
chart1.SetProperties p1
End sub
/*********************************************/
Regards
Vinod