Scroll Bar and Spin Button for a Dynamic Excel Chart

preview_player
Показать описание
In this tutorial show you how to visualize your data by using a scroll bar and a spin button
Before creating my chart, I need to build a helper table using some Dynamic array functions.
So let's see how we do that in Excel
Рекомендации по теме
Комментарии
Автор

I love learning new things ❤❤❤ Thank you!!!

yonnab
Автор

AMAZING STUFF NABIL, LOVE YOUR INGENUITY

PrabhakarMurthy-ys
Автор

Excellent Nabil. It would be necessary to control possible Ref errors when going down with the Scroll Bar and reaching the last values. Very efficient and dynamic. 1000 Thanks.

IvanCortinas_ES
Автор

Thank you Nabil for this awesome Video.
It would be nice when this data expand or contract, the scroll bar would expand and contract accordingly. I guess this would require active X control and VBA events

nadermounir
Автор

Good day sir, maybe you can help me. How can I grab a chart from another worksheet base on my drop list on my present worksheet? Thank you.

bicoldurante