Fully dynamic Chart in Excel with Scroll bar and Spin button form controls

#FormControls #DynamicCharts
In this video you will learn how to create 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.
Please download the practice file from below given link:
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...

[@dahlhouseEH]

Pk is an EXPERT... 15min. that's it. works exactly the way he demos. easy to follow EXPERT. that's rare.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@cesarsaldana3429]

Wouuuu!!! Its Fantastic Chart....Thank you, Master.

[@querrythis]

Watching this video from South America. Very helpful. I like it over mouse click. Thanks for sharing.

[@PKAnExcelExpert]

Glad it was helpful!

[@FaysalEasyExcel]

it's another great content i've seen over youtube about excel. thanks a lot.

[@PKAnExcelExpert]

Glad you think so!

[@axelbender1]

this is so great!!!! thanks!!

[@yulinliu850]

Very cool Excel skills! Thanks for sharing!

[@PKAnExcelExpert]

Thank you! Cheers!

[@mhrl9716]

Thanks for your effort, You're one of the best excel instructor

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@millet2963]

I love all your videos and tutorials. Appreciate if this chart has a comparison on last year. Basically I want to create a dynamic chart in excel comparing the daily sales on weekly basis from last year to this year and I cant find any videos that I can copy. Hope you can help and create one. Thanks so much and more power

[@kenatsharaby]

great video! clear and simple

[@PKAnExcelExpert]

Thanks

[@rohitgurung909]

Wow!! This was amazing...This is what I was looking for....Thank you my friend....Keep up the good work....

[@PKAnExcelExpert]

Glad it helped

[@shyjumathew07]

Excellent, thanks PK

[@hossamyoussef8733]

Here we can add a date in this wonderful content

[@michaelgolding8129]

Another great lesson, many thanks PK, gong to use this for Analysis for our team.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mostaphabouta6787]

Incredible and inteligent work, another like for you and thank you so much ;-)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@indrac6085]

Great video.. One trick to make it easier when with lots of data.. Thank you...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@francispaulonicomedes7748]

God tier excel skill
Thanks for knowledge 🥂❤️🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vishal_kiyaan]

I am referring a lots of Excel Page, but you are unique and only one true excel champion....

[@KhalilAhmad74036]

Very detailed explanation! Thanks, Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nadermounir8228]

Great ideas PK absolutely amazing. Keep up the hard work 💪 👌

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lukev730]

Amazing Pk! you are a ⭐️ star

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sumonmajumdar6992]

Very helpful tutorial. Many thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@MrManish261000]

Very interesting sir. Thanks a lot. Please keep sharing such learning materials.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@tsrinivas2406]

Very useful Video. Thanks for sharing your knowledge

[@PKAnExcelExpert]

My pleasure

[@virendrasingh2470]

Hi PK .. It's really a wonderful video for creating this dynamic chart

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@ecomarketmarket7171]

thank very much 😊🙏

[@sharonsfella]

Brilliant...I can use this right now... thanks

[@PKAnExcelExpert]

Great!

[@jawaharthakur2066]

Thank you so much sir.

[@zvikabar-kochva3641]

Very nice and useful. Thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bennyassmunch]

Thank you for the information

[@PKAnExcelExpert]

Most welcome

[@ramanchandrangobalan2220]

Mr PK, awesome , video. you 're worthy to call an excel EXPERT.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ramanchandrangobalan2220]

Mr Pk I send email to you on "ref" error while creating dynamic Chart , when connecting index + row. please advise

[@briandennehy6380]

Superb thank you I'll have loads of uses for this

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@lukev730]

PK you are excel super star 🌟 ⭐️

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Luciano_mp]

Great, thanks.👍👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@massgifts7876]

Excellent PK.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@29937889]

Fantastic video 👌

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@meciturun4649]

Thanks a lot.

[@PKAnExcelExpert]

Most welcome!

[@molala225]

impressive! thumbs up

[@PKAnExcelExpert]

Thanks a lot!

[@syedmohdwaqas6404]

Always Awsome.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@newtrends2.o389]

Very helpful 👌

[@PKAnExcelExpert]

Thanks🙏

[@samuelfranciscogarcia1440]

Ohhhh. It is perfect your job.🎂

[@PKAnExcelExpert]

Thanks

[@carmenhixson8213]

Is there a way to add a scroll to a pivot chart? Or can I use the same process seen here? Thank you for the awesome video!

[@suhailnbd]

Excellent pk👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tobayekaina8610]

Thanks for sharing. Any idea if i have 2 data series (sale and target)?

[@majidsiddique8227]

Very Well Done

[@PKAnExcelExpert]

Thank you very much!

[@gauravgandhi6371]

@@PKAnExcelExpert Can you Please arrange SALES Fan MIS SALES Figure Month cummutaive chart.
Please revert Back

[@hayatikoc75]

Teşekkürler

[@PKAnExcelExpert]

İzlediğiniz için teşekkürler

[@omnarayan7066]

Great 👍

[@PKAnExcelExpert]

Most welcome🙏

[@user-eu5zv7ps9y]

Genius.

[@PKAnExcelExpert]

Thanks

[@humaypashayeva577]

Amazing😋👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@parveenverma3723]

Great video PK. Thanks for sharing your valuable knowledge through this video. I have only one query please sort if you can. Actually I have tried a lot to select dynamic table, scroll bar, spin button and rectangle alongwith to create a group of all but failed. Please guide how to select all items to create a group of all items of dynamic table. Actually I am not very frequent with MS excel. Thanks in advance.

[@winniedlaydy1013]

Amazing

[@PKAnExcelExpert]

Thank you! Cheers!

[@TheInterestedable]

excellent

[@PKAnExcelExpert]

Many many thanks

[@adrien8768]

I love you :)

[@PKAnExcelExpert]

Thanks

[@user-bu9wt5gh8u]

awonderful job thanks my dear. Can you plz do dashbord Regarding sales and sales return

[@PKAnExcelExpert]

Thanks. I will try

[@Cricketmasterio2012]

Hi, can we use this technique for pivot chart and pivot table...I saw these have link and you cannot assign the scroll or spin button to the chart source data

[@levelupexcelskill]

Many thanks for this video you teach excellent.
Could you please make a video to make addins because my ribbonx not working and I don't know how to use custom UI

[@PKAnExcelExpert]

Ok I will try

[@gokulgovindanclusterhead9392]

Excellent and useful tip.
With same dynamic mode, how can we have top 5 out of 20 in the chart display.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Michael_Alaska]

Great tutorial. It's a shame that there doesn't seem to be a way to make the maximum on the scroll bar dynamic so it expands with the data table.

[@nadermounir8228]

If we don't know how long the data is then wouldn't this be an issue ? We may keep scrolling and go into a range where no data is there. In this case, the graph may have zero values?

[@smartwork4768]

Hello PK
I have below query,
How shell i do color scale conditional formatting in entire table formatted raw by every alternative column.
Also any future raw or column to be added the it also should take similar formatting in auto mode.
Thanking you in advance.
Regards
Bharat

[@marcq877]

This is great, But how can you apply the same to a pivot table? When I tried, I cannot change the data. It is all greyed out.

[@ruchitradia7063]

Hi PK
Thanks for the video.
However, as the data moves ahead, how to add the dates?
as i have data, wherein there were 2 main details which got added horizontally and vertically, but i want to show the details, as date wise.
so for date 1st Feb 20, there are 10 names, with login time, again for date 2nd feb 20, i want to show all details and so forth.
so need to understand, ow to add the dates.??

[@SavageKing1292]

Formula for columns Header! can we change columns dynamically?

[@sachinshinde5997]

Very nice and useful...
I have one question...
Is it possible to make Bank Reconciliation Statement with the help of VBA....if yes, please make video..

[@PKAnExcelExpert]

Yes, it is possible. I will definitely try to make such video

[@vikitashah4825]

PK can we have scroll bar and spin buttons in pivot chart

[@razzaqabdur7519]

Good morning Sir, Is Excell 2016 supported these formulas or not I am trying but it could not work

[@rimshakanwal8923]

Can we create this chart with pivot table??

[@farooq346]

Sir i want to learn chart for mean and standard deviation please teach me

[@gloryofislam9731]

in format control why there don't have control option?

[@prasenjitmukherjee5010]

Excellent tutorial Sir. But, what if the number of columns are more than one? Pls guide me Sir.

[@PKAnExcelExpert]

Will upload soon

[@johnpamandanan8840]

Question on this please..
How can I lock the scroll bar and/or spin buttons when it reach the end?

[@PKAnExcelExpert]

In the format control of Spin button or Scroll bar, define your minimum and maximum range accordingly.

[@pankaj4kamal]

Hello sir...
I want to know.. How to genrate alphanumeric id (like employee ID).. Which is auto increment, in vba user form, and while I submit or save the data to excel then same id add in excel cell. Plzz guide me sir.

[@lovelybhardwaj2027]

Sir how can we make a chart where we can view all the data of a particular section by just selecting no. Of data we want read

[@noorm516]

How we can do this dynamic chart with dropdown list?

[@aftabjaved4784]

From your accent it seems as if you are a sri lankan. Anyways excellent work

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ManojKumar-tj7hv]

Hi can anyone tell me how to add this into PPT

[@nohahesham3335]

can't find the practice file!

[@PKAnExcelExpert]

You can download it from below webpage:
www.pk-anexcelexpert.com/fully-dynamic-chart-in-excel-with-scroll-bar-and-spin-button/

[@gauravgandhi6371]

But where employee against Sales is showing in chart.
We need same chart Branch region employee wise can it possible... pls revert Back..

[@nadermounir8228]

The name manager is giving an error when using it in the chart I tried to check the formula and fix it in the name manager few times. I used absolute reference and still get errors.

[@pankajyadav-on9id]

Please make one video

[@shyjumathew07]

How to roll chart based on increased column value

[@sukhdevsingh-xm8nz]

Thanx sir. Pls sir vba ka bata dijiye kaha se kare hindi mai koi bhi badiya channel ni hai pure youtube pe ap hi batado koi channel jisne pura vba karaya ho jo companies mai kam bhi aaye....only excel seekh ke bhi koi fayada ni hoga jb tk vba air vba .net ni aayga plss help karo ..ni to private tution hi lagani padegi....jb corona khatam hoga ....

[@karanpatil7887]

Fiance company recovery inventory managment system using vba excel

[@nadermounir8228]

I downloaded your practice file and I used the name manager u had built on your same sheet and also gave me an error. The chart doesn't accept the name manager that u had created. Very bizarre

[@2111Nelly]

This does not work at all! I tried the formula a couple of times and it never works :(

[@PKAnExcelExpert]

Download the practice file and see the formula there

[@alpeshraymane3861]

continue advertisement

[@pankajyadav-on9id]

Mis report

[@safiqueahemad8377]

Not clear.

[@khalidmajeed2886]

if you distribute knowledge Allah will give you nobody knows

[@PKAnExcelExpert]

Thanks Khalid, for your blessings.

[@vishalbharakhada3357]

Amazing

[@PKAnExcelExpert]

Thanks