Charts With Scrollbars ( SOLVED)

[AzadPadamsey]

Hi,
This is a cross posting:http://www.thecodecage.com/forumz/forumdisplay.php?s=&daysprune=&f=64
Please see sample file:
I have a worksheet with 2 charts (possible more in future).
What I want is a panel with a scrollbar so that I can view each chart individually.
Please see attachment.
Regards
Azad

 

[Hui]

Azad

You have two choices

1. Is to generate the data and update a single chart
2. Generate multiple charts and select them

I prefer the first method and have attached your data formated for that

See attached file:

Method two is described here:
http://chandoo.org/wp/2009/05/19/dynamic-charts-in-excel/
http://chandoo.org/wp/2013/04/23/interactive-chart-in-excel-tutorial/

 

[AzadPadamsey]

Hui,
Can you help to do the 2nd Method with attachment.
Thanks for so much help.
Regards
Azad

 

[Hui]

Please see your data using method 2 in attached file:

 

[AzadPadamsey]

Hui,
Many thanks for your valuable help.
Regard
Azad
I will consider this as solved