I have 3 bar charts with Scroll bar in X axis. Is it possible to scroll all the three bar charts scroll at the same time using macros.
Consider three Bar Charts as Chart A,Chart B,Chart C With scroll bar. If scroll the scroll bar in any of the chart the two charts scroll bar also shoul get scrolled accordingly.
My first thought is that it is not possible, as there is no "onscroll" event.
Maybe this could be simulated by putting a Slider object on the sheet. The slide object could set variables like mindate and maxdate. Then the charts could use those variables in calculated dimensions.
This is interesting question for sure. But I agree with mwoolf... we can't set the properties or events for onscroll. We can dynamically enable or disable this feature by using XAxisScroll property for IChartProperties class. Please can you post the QV document with charts and we can think of using the sliders for your requirement.
Although, I have used "Max Visible Number (1-100)" with a slider. I mean I used this one where user can decide on how many Dimensions he wanted to see. Also this techique comes more handy when you have dynamic sorting for showing the Top 10% and Bottom 10% (Using the expressions).
Thanks for the response. Sorry i would not be able to post the application here but i could explain you what i trying to do . I am trying to split a line chart with one dimension and three expressions in to three charts . Since the expressions values are overlapping each other and users are not having the better clarity. User need to compare the three expressions at the same time. So i could place it as three charts each one has individual expressions and dimension is around 25 values so i have to go for the Scroll bar. So when users scroll the scroll bar relatively the other two charts scorll bar also has to be scrolled so that it will be easy for comparing the values instead user has to manuall scroll all the three charts then comparing it. I was not able to check the possibility of doing this using the extension or Workbench/OCX. Please do let me know if you need any further clarification, I will try to post some manipulated sample data. I understand we can try the Trellis but it is not clear again since the number of dimensional values. And split axis due to three expressions.
