Multiply Your Dashboard Space with A Combo Box

Рет қаралды 2,598

Күн бұрын

When creating a dashboard having lots of visualizations, you run into the problem of fitting all your charts in one single screen.
In this tutorial I show you how to multiply the Space of your dashboard by using a combo box
To book a Corporate Training for your organization, explore our extensive Course Catalog or request a Quote, click Here:
www.OfficeInstructor.com
With your support, I can post a lot more Free Tutorials so please subscribe to my channel to help me do more.

Пікірлер: 22

@ohdjrp4 11 ай бұрын

Thanks for this Mr Nabil!

@hankgrimes1806 9 ай бұрын

You, sir, are in a class of your own! I actually enjoy binge-watching your videos because your presentation style is both crystal-clear and inspirational! Thank you, so much, for sharing your knowledge and your "obvious" passion for helping me accomplish projects that I could NOT have done on my own! يرجى الاستمرار في المشاركة!

@nadermounir8228 11 ай бұрын

Thank you Nabil very nice tutorial 👌

@Officeinstructor 11 ай бұрын

You are most welcome

@alializadeh8195 11 ай бұрын

Thanks, Very usefyl as always... Maybe please make some videos on Ms Access tips & tricks or database making ....

@Officeinstructor 11 ай бұрын

Sure I will

@mugundhans400 10 ай бұрын

Amazing and appreciate it

@izzatkiswani 11 ай бұрын

As always ,brilliant ideas ,Thank you !!!!!

@Officeinstructor 11 ай бұрын

Glad you like them!

@Luciano_mp 11 ай бұрын

Very good, useful. Thank you Nabil!

@Officeinstructor 11 ай бұрын

Glad you liked it

@briandennehy6380 11 ай бұрын

Superb as always 🙏

@Officeinstructor 11 ай бұрын

Thanks a lot 😊

@AdnanKhan-fc3uc 11 ай бұрын

Best but likely difficult for me due to basic practice missing.

@maverick19_ 11 ай бұрын

Thanks Nabil, I see numerous comments on issues, perhaps a question is what office package you are using as each slightly differs in function.

@Officeinstructor 11 ай бұрын

I'm using Office 365 but this functionality works in any version 2016 or later. the TEXTJOIN function is available starting from 2019 but it's just to avoid typing the named Ranges in the CHOOSE function so you can omit it and type in the Defined Name dialog box. In older versions, each name must be in double quotes

@tanweerabbasabbas649 11 ай бұрын

same file attached would have been better😊🥰

@Officeinstructor 11 ай бұрын

Yes, you are right. Honestly, I used to attach files but I will resume doing that with more viewers interaction.

@binkekl 11 ай бұрын

Do this even work in Excel for MAC?

@IvanCortinas_ES 11 ай бұрын

It didn't work for me Nabil. Probably a locale problem with ";" and "," and does not correctly recognize the names of the charts. Thank you anyway.

@Officeinstructor 11 ай бұрын

try to recreate the CHOOSE Function by typing each named range in double quotes rather than using the TEXTJOIN as I did. Anyway, thank you for watching.

@IvanCortinas_ES 11 ай бұрын

@@Officeinstructor The problem is with the defined names of the graphics that the Camera command does not recognize later. Anyway, thanks anyway Nabil.