Dynamic Chart with Form Controls
Charts and Visualization

Fully dynamic chart in Excel with Scroll bar and Spin button

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 20 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:

Click here to download this template.

My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.