Flexible chart...The drop-down menu in cell H1 gives me an option to resize the top chart.

[omega0010]

Is there any way to do the same to the stock chart below that?
Thanks for your time and help ( kindly make the changes in the file itself and upload the file).

[Estevaoba]

I created dynamic named ranges, one for each column in your data, with this formula for column B, Time, for example:

Please Login or Register  to view this content.

Then I use those named ranges for data selection in your chart.

Please check file attached.
The data in columns M:T were just for checking and can be deleted.

Good luck!

[omega0010]

Absolutely Amazing ! You have done the impossible ! Thanks a ton for your time, effort and kindness.
It works like Magic !

[omega0010]

You have done a great job but, unfortunately every time we resize the chart, it gets cut from the right side. As such it does not make any sense.
the basic idea is to resize it ( or cut it) from the left side so that you look at say , the last 30, last 50, last hundred and last 120. Currently it shows the first 30, first 50, first 100 and first 120. Can you please think of something which can correct this ( and please upload the file ... as I don't know anything about these things). Thanks.

[Estevaoba]

Hi.
I forgot to lock the range for the COUNTA in those named ranges. That's why it made no sense.
Sorry about that. The correct formula is this:

Please Login or Register  to view this content.

Please check attachment.

[omega0010]

Hey Estevaoba !

Thanks for the great effort and time. It is very kind of you. God Bless !

[Estevaoba]

You're welcome. Glad to help.
Thanks for rep point added and for marking the thread solved.