Issue related to scroll bar of Bar chart

[#1]

Hi all,

I have a requirement of fixing the position of scrollbar in a Bar chart. I want that the scrollbar always remain at the extreme right end of the chart not at its normal position i.e  extreme left end.

PFA screens shot.

[sasikanth]

in layout check the check box

Prererve scroll bar position

[selvakumarsr]

First Scroll to right and Check Preserve Scroll Position in properties..

[ashfaq_haseeb]

Hi Check the below macro.

Set rep = ActiveDocument.GetSheetObject("Document\CH10")

set p = rep.GetProperties

p.ChartProperties.XScrollInitRight = True

rep.SetProperties p

Regards

ASHFAQ

[ashfaq_haseeb · Accepted solution]

Hi you can even try below

go to Chart properties --> presentation tab, Then select "Reversed" and  "Show/Enable X-axis Scrollbar"

It will preserve your scroll position even after restart.

Regards

ASHFAQ

[#6]

Hi Selva

Thanks for your reply. But is is not working.

[ashfaq_haseeb]

Hi Vitul try my second reply.

Regards

ASHFAQ

[#8]

Thanks Ashfaq,

Its working.