Home>Blogs>Charts and Visualization>Fully dynamic chart in Excel with Scroll bar and Spin button
Dynamic Chart with Form Controls
Charts and Visualization

Fully dynamic chart in Excel with Scroll bar and Spin button

Are you ready to unleash the full potential of Excel’s data analysis and visualization capabilities? Hold on tight, because we’re diving into the mysterious realm of creating a fully dynamic chart in Excel with the enigmatic scroll bar and spin button!


A dynamic chart, you ask? Think of it as a chart that updates with each twist and turn of the data, keeping you one step ahead without having to manually adjust every time. But how do we make this magic happen? By harnessing the power of two deceptively simple tools: the scroll bar and spin button.

The scroll bar, a graphical wonder, gives you the ability to select a value from a range of options by sliding your thumb along a track. And in Excel, it’s used to control the range of data displayed in a chart.

But wait, there’s more! The spin button, another graphical gem, allows you to select a value from a range by clicking on the up or down arrows. And in Excel, it can be used to control a specific data point in the chart.

So, are you ready to create a fully dynamic chart in Excel that seamlessly integrates the scroll bar and spin button? Follow these steps and behold the magic unfold!

In this article, we have created a fully dynamic chart using Excel Form Controls and Name Manager. We have created dynamic ranges for chart with scrollbar and spin button form control and Indirect formula. Scroll bar we have used the scroll bar to show to rolling employees in sales chart. Spin button is to add the new employee in the chart. You can see max twenty employee in the chart using spin button.

Dynamic Column chart
Dynamic Column chart

We have used this trick for Bar chart also.

Dynamic Bar Chart
Dynamic Bar Chart

Watch the step-by-step video tutorial to learn it:

And so, we reach the finale of our journey into the mystical world of dynamic chart creation in Excel! By combining the intricate scroll bar and the spunky spin button, we have unlocked a formidable tool that brings data analysis and visualization to a whole new level.

Gone are the days of manual updates and tedious chart adjustments. With this technique, you now have the ability to effortlessly create charts that dynamically adapt and update with each fluctuation in your data. Imagine, with just a few clicks, you can now gain deeper insights and a clearer understanding of your data, all while saving time and streamlining your analysis process.

So, don’t hesitate, embrace the power of dynamic charts in Excel and witness the transformative effects it can have on your data analysis and visualization endeavors!

Click here to download this template.

Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!