Stunning Visualizations with Advanced Functions and Option Buttons

When crafting visualizations, your aim is to ensure they are informative, interactive, and engaging.
In this tutorial, I will demonstrate how to merge the capabilities of Option Buttons with Advanced Functions (CHOOSE, FILTER, SWITCH, UNIQUE, LET, SUMIFS) to produce Stunning visualizations. This functionality can be used for individual charts in a report or as part of a bigger dashboard.
Let's begin our exploration.
########################################################
To book a Corporate Training at Client Site or Remote, and get a quote: www.OfficeInstructor.com
***********************************************************************************
Please support this channel by Subscribing, Liking and Commenting.

[@IvanCortinas_ES]

Spectacular as always.
A real pleasure to see these wonders of combinations. Thank you my friend!!!

[@Officeinstructor]

Many thanks my friend!

[@erikguzik8204]

Always some little trick to make it look excellent. Always love these videos. Great work !

[@Officeinstructor]

Much appreciated Erik

[@gandhisunil3]

Hi Nabil, Great to have amazing video Every video is best to previous ones....
Most of your videos truely indicate the worth and simplicity of Let function

[@Officeinstructor]

I am a big fan of the LET function. Thanks for watching.

[@chidoziejoseph8579]

Wow! Amazing as always. I have been following your videos and I must say they have been very inspiring and eye opening. Thanks for this

[@nadermounir8228]

Very insightful Video. Thank you Nabil for sharing ur knowledge with us:)

[@Officeinstructor]

Glad you liked it!

[@nsanch0181]

Thank you for the great video. There was a lot in there that I want to learn. I have to figure out that let function. Thank you so much.

[@richardhay645]

Good!!

[@Officeinstructor]

Thanks!

[@jesstatz8695]

Instead, I used your method of getting the name of a chart inserted and just used the Pivot Chart with your tip on varying colors. The Pivot chart has filters right on the chart. It looks cleaner to me.

[@alializadeh8195]

Appreciated your kind ....
Also if you start to make Ms Access videos, it will be very helpfull...

[@Officeinstructor]

You are welcome. For Access, I have a basic course posted 4 years ago. I do not have the intention for more Access tutorials soon.

[@jesstatz8695]

I had to add another series. In this example, maybe add “International” to East, West, etc. I had to Alt+F1 on the chart again so the table legend would pick-up properly, else it said “count” on the new series. A little disappointing.