Impressive Dynamic Chart With Title Drop List

In this tutorial I show you how to switch the source data for a chart by using drop lists;
and then we take our chart to a different horizon, by making the chart title itself act as a drop list
For this tutorial , you can download Both: The Exercise File to follow along and a Step by Step instructions Guide for your reference. here is the link

To Book a Corporate Training (Remotely or at Client site)
To Book a Microsoft Office Specialist Exam

To read my step by step articles visit:

You can keep supporting my channel by sharing the video, by writing a comment and by subscribing to my channel… and ring the bell to be notified when new videos are released… The Best Is Yet To Come.

[MonikaKalani]

Mr. Nabil. Thank you so much for sharing the knowledge. I have learned a lot from your videos. Working on excel is my passion and your videos give wings to my imagination. Excel is a hidden treasure and you are a treasure hunter.

[vipulDJhaveri]

Dear Mr. Nabil, with such a magical touch all our reports will have winning edge, Creativity at its Best Practicality, Thanks a lot sir !!!

[aig]

Dear Mr. Nabil thank you so much (again and again ) for opening my eyes to so many new stuff cant wait for the next video

[Abioladavid]

Great tutorial... Undoubtedly, the best is yet to come👍😀

[apn]

Excellent presentation Nabil....Iam from India and a great fan of yours. The way you explain even a complex trick shows your passion in excel. Thanks a lot for sharing your knowledge..Keep this rolling. God bless you.

[piarchanddogra]

We learn again a magical trick 👍👍. Thanks for sharing.

[IvanCortinas_ES]

Supervideo Nabil. Thank you very much! Excellent trick the final part with the macro. Awesome!!

[VSIOPPLANNER]

Thanks for your wonderful training !!!

[abdoutawfik]

Thank very very much i like all you do i'm from morroco. i use your tuto in my job and i like to Now more about userform can you do items

[argokusumandani]

Mr. Nabil i want to ask, i have enjoying learning Excel from your tutorial. I try to apply your tutorial on my jobs. In the your last video about "comparison chart for dashboard" i try to implement that with my own. Unfortunately the value on increasing and decreasing part some time have error (no value on the chart) when i try to switch data with drop down list. Please advice what can i do to fix that kind of error. Many thanks for your help.

[saehu]

Nice tutorial, but too much efforts for me. I'm prefer fix the data and use pivotchart