ChartSheet scroll axes maximum value

[jwExcel]

Please can someone help me with the following problem?

I have a ChartSheet and I want to include a scrollbar that allows the user to scroll the maximum value of the Chart's x-axis.

I have added a form control scrollbar since the ActiveX type wont work on a ChartSheet.

 

[Hui]

JwExcel


Firstly, welcome to the Chandoo.org Forums


I will admit that your post taught me something new today and so it is a good question to ask.

I never knew that you couldn't put Active X controls on Chart Sheets?

So thankyou.


You can insert form Controls and there is no reason why not to use a Form Control, which can be linked to a cell on another worksheet


You can also link it to a Macro which will be triggered when it changes