Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want the scroll bar always this right even after making some selection.
Thanks for help
I think this is achieved with the checkbox "Reversed" which is located on the "Presentation" tab, in the upper right corner.
The problem with Reversed is once any filter or selection is applied, the scroll bar will no longer appear at the end. Reversed is only applied on document open. Any ideas how to always force it to the end?
Thanks,
J
This can be accomplished by runnig the following macro once (you don't need to trigger it to run at document open or any other event). The easiest way is to use the "Edit Module" window's Test button. The macro below sets the scrollbar to always start from the far end of the chart (making a selection does not reset the state). Change the string "CH82" to match your chart's Object Id.
--
Sub SetScrollRight
set chart1 = ActiveDocument.GetSheetObject("CH82")
set p1 = chart1.GetProperties
p1.ChartProperties.XScrollInitRight = true
chart1.SetProperties p1
End sub
--
Hope this helps
Can you do this so the scroll bar is positioned based on a date value? In other words, position the scroll bar where date=max(date)...or something like that?
I have a line chart that represents Year-over-Year by day. By default the scroll bar begins on the left, at Jan 1. On the right is December 31, but I don't want to see December because we're only in the middle of July. The chart shows only a 30-day window. I'd like the chart to have the max(date) (date to which the report is refreshed) be the center of the 30-day window. Any thoughts?
By the way, I should mention that I have daily/weekly/monthly charts, each visible when a variable called Toggleview = 1, 2 or 3, respectively. It'd be great if everytime the button that activiates the Daily graphs (Toggleveiw=1) is pressed the defaul position of the scroll bar is in the middle of the chart.
Thanks in advance for any thoughts.
I don't believe it's possible to default the scrollbar position to some particular point in the middle of the chart. I believe your options are all the way to the left or all the way to the right.
I did not get it done .It did not work.