Create INTERACTIVE Excel Dashboards With Option Buttons

Create INTERACTIVE Excel Dashboards With Option Buttons | How to use Radio Buttons

Рет қаралды 590,044

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Discover how to switch between charts in Microsoft Excel using radio buttons! This simple yet powerful trick is perfect for crafting interactive dashboards.
⬇️ Download the Workbook from here: pages.xelplus.com/radio-butto...
✅ What You'll Learn:
▪️ Setting up radio (option) buttons in Excel: A complete guide to adding and configuring radio buttons for interactive chart control.
▪️ Data preparation: Tips on cleaning and preparing your data for charting without altering the source.
▪️ Dynamic chart creation: Learn to use the FILTER function for selecting specific data sets based on the chosen option button.
▪️ Sorting data dynamically: Implement the SORT function to automatically organize your chart data.
▪️ Enhancing chart interactivity: Strategies for handling varying data categories and creating dynamic chart ranges using the Name Manager.
▪️ Dynamic chart titles: A tutorial on making your chart titles change with your data selection.
In this video I'll show you how you can allow a user to choose the data they want to see on a chart. You'll learn to switch the chart view based on user selection. I'll show you how to add the developer tab to Excel, how to use form controls and how to group radio buttons together in case you have more than one set of option buttons.
We'll also cover how to use the FILTER and the SWITCH functions in Excel for the data preparation. And finally I'll show you a trick to make your chart range dynamic to avoid gaps or missing data in the chart. This way your chart range and chart axis adjusts based on the size of your data.
★★★ My Online Excel Courses ► www.xelplus.com/courses/
00:00 How to Create an Interactive Chart with Radio / Option Buttons
00:14 How to Insert Option Buttons in Excel
04:07 Prepare the Raw Data for the Chart
06:38 Insert and Format The Chart
08:16 How to Make Chart Ranges Dynamic
12:14 How to Create Dynamic Chart Titles
13:27 Wrap Up
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #dashboard

Пікірлер: 529

@LeilaGharani 5 ай бұрын

Grab the file I used in the video from here 👉 pages.xelplus.com/radio-buttons-file

@excel_along_the_way 3 жыл бұрын

Thank you Leila, what was new for me was the grouping of the option buttons. I've been using option buttons for a long time and never knew you can group them on one sheet. This is definitely a game changer for me.

@kristoferbrown8007 3 жыл бұрын

I had no idea that you can use the # to automatically grab the data range, despite the size. Game changer.

@Meanna12 2 жыл бұрын

Leila, you always impress me with the simplicity to create a dashboard. Please continue these vlogs. I am sure that you have big fans

@kyleutuber 3 жыл бұрын

Such an elegant solution! I love that you always drop in small tips and tricks adjacent to the topic at hand. In this one, I learned SWITCH as a more flexible alternative to CHOOSE. Thanks!

@mariyammalshetty9110 2 жыл бұрын

Kojpko

@EliotPowell 3 жыл бұрын

My team thinks I know Excel stuff. Really, I just subscribe to Leila 'cause she knows stuff!

@austinc124 3 жыл бұрын

Same here. My team: "how do you (insert impossible function here) in excel? Me: (Sends link to Leila's video).

@EliotPowell 3 жыл бұрын

@@austinc124 Exactly

@iantau3455 2 жыл бұрын

Thats me too😊

@sammixie3753 2 жыл бұрын

Same here, LOL.

@saromijuwon7151 2 жыл бұрын

Same here lol

@ArticulateDesignASMR 3 жыл бұрын

I have watched so many of your videos for work 🙈 Thank you very much :D

@LeilaGharani 3 жыл бұрын

Glad you like them!

@MasterofPlay7 2 жыл бұрын

did you get caught by boss?

@vasistreddy968 3 жыл бұрын

This will take decades for me if i try to build this on my own. This Radio button template is so cool. Kudos to Leila for sharing her knowledge!

@damlayldz1907 2 жыл бұрын

Thank you for explaining EASILY 🥰 I have been spending my 2 days to find a video that really demonstrate interactive excel dashboards for beginners. I will present a slide in office and It will save my life

@TylerStanczak 3 жыл бұрын

This is going to be a game changer. Thank you for sharing this Leila :)

@shashankshekhar4441 3 жыл бұрын

Thank you so much !! I start my day by watching one of your videos, and this makes me feel that I have learnt something new today.

@soumadip.m Жыл бұрын

Seriously, Leila and Chandoo, these 2 legends changed the way I think and use data in excel. You helped me crack a new job even. Thank you so much!

@aperkinsvt 3 жыл бұрын

Great video! Good reminder about using the SWITCH function. Also, clever use of named ranges for chart data ranges. Thank you!

@LeilaGharani 3 жыл бұрын

Glad you liked it, Andy!

@nairobi203 Жыл бұрын

If I had to do this data presentation my first thought would probably have been a pivot table, slicers and a pivot chart, but this solution is indeed very inspiring. I learnt many new formulas, which I did not use so far. In addition I also included radio buttons to choose how I want the values to be sorted (so I put the Grouping function you explained at the beginning) instead of hard coding it into the formula. And I named most of the ranges you used. Thanks for sharing

@Dubai711 2 жыл бұрын

Amaaaaazing functions Leila !!! You impress me every day! I become addicted to your videos. I learn a new thing every day almost. Thank you so much!

@mirkowilhelm4792 3 жыл бұрын

simply perfect - your teaching skills are great - thank you

@eliasmeez1827 2 жыл бұрын

I really enjoy your videos! So much to learn to leverage our skills and submit distinctive reports at work ;) I love the channel's content.

@nevermind4780 3 жыл бұрын

You always amazed me with innovative ideas and techniques to use formula.

@binhthai078 3 жыл бұрын

You never stop surprising us with those MS Office tips, I've never find it boring

@vida1719 3 жыл бұрын

This is really the next level! Great application of Excel features to achieve interactivity

@ltcmdc1782 Жыл бұрын

OMG! I learn so much from you every video I watch. You are always clear and make things easy to understand!

@davidk919 2 жыл бұрын

Wow!, It's awesome and for real life practical use. It uses new functions and the silent radio buttons to look very professional and simple

@wayneedmondson1065 3 жыл бұрын

Hi Leila. Awesome tutorial! Full of great tips and tricks. You make it look so easy. I especially like making everything dynamic which is always the goal. Thank for sharing :)) Thumbs up!!

@LeilaGharani 3 жыл бұрын

Thanks so much! 😊

@scottnero 2 жыл бұрын

Your english is wonderful and well pronounced, it makes listening to your lessons wonderful. Great job!

@nyashadzashemandizera4475 3 жыл бұрын

Thanks a million Leila, I loved this. May you also do something on "pasting in selection" I have been battling with this my entire life. Thanks once again for saving lives, one spreadsheet at a time ;)

@KasSyl1234 2 жыл бұрын

Perfect! Informational stuff. Love it

@zioeddie65 2 жыл бұрын

Not only you really know what you are talking about, but the way you explain is awesome! My sincere congratulations...

@PeymanSayyadi 3 жыл бұрын

Every time I watch your videos, I feel like an Excel newbie. Thanks for these great lessons.

@LeilaGharani 3 жыл бұрын

You're very welcome!

@robjchristopher 3 жыл бұрын

That is really clever - I'll definately be using this as inspiration. Thanks!

@mashokhan8811 Жыл бұрын

REALLY FALL in love with this amazing technique and you are already in my heart

@CanTukel-db1qp 2 ай бұрын

mind blowing! Thank you!

@BM-zd3vs Жыл бұрын

Just subscribed! Respect to all excel gurus 🙏

@lolikon30 3 жыл бұрын

I love the way you combine different functions. Thanks for sharing with us.

@LeilaGharani 3 жыл бұрын

You are so welcome!

@ali8bilal 2 жыл бұрын

You are the only one giving magic in excel. I never seen any other you tube channel like your channel. You are magician in excel. Thanks a lot for your efforts.

@ezequielbosch1321 Жыл бұрын

Super clear (as usual) and will make my work that much easier!

@bawwapark 2 жыл бұрын

Wonderful Trick Leila, Grate !!!

@mohamadmneimneh4036 Жыл бұрын

Thank you... I have been learning a lot from you! You're excel knowhow is mind-blowing!

@METN 3 жыл бұрын

Coool!!! The wonderwoman in Action!! Grettings Leila

@rkalwaysravi 3 жыл бұрын

Yet another great tutorial 👍🏻

@paintandgame 3 жыл бұрын

Funny you mention wonderwoman cos i thought Gal Gadot do look almost as beautiful as Leila

@davidferrick 3 жыл бұрын

During my very brief lunch breaks I simply sit on KZfaq and watch your videos, even if I don't have a current need I love the ideas that you inject into my brain for upcoming projects. :)

@LeilaGharani 3 жыл бұрын

Thank you for spending your lunch with me :)

@ricardoromo96 3 жыл бұрын

Awesome video!! Even when I used the FILTER formula, I used the OFFSET function to create a named range. Didn't know I could use the '#" in there. Thanks!!

@eloufie Жыл бұрын

I thought I am good at excel, however you really impressed me with new stuff, Leila.. Well done, and thanks a lot for the amazing functions. 👏🏻

@ym10up 2 жыл бұрын

This is so satisfying!!!

@CJ-gn8ud 3 жыл бұрын

Thank you Leila! This is so helpful, don't need to manually select the chart data range is so powerfull!

@LeilaGharani 3 жыл бұрын

Glad you like it!

@fuzzylon 8 ай бұрын

Thank you for this! There are lots of things here I didn't know before and I will find really useful.

@joshjillson5433 3 жыл бұрын

I've been trying to improve my workbook "summaries" to a dashboard. Still more work to get fluid, but this is awesome - and 'saved' :) THANKS!! Love you videos!!!!!

@ikartiko Жыл бұрын

Very interesting..thank you for clear explanation Leila....

@vs_gaming3013 2 жыл бұрын

That was brilliant. Thanks!

@mateuszlika2652 Жыл бұрын

These things you do here are great! Thanks a lot!

@savioseona 3 жыл бұрын

Great video Leila! So many useful tips covered in a short video.

@LeilaGharani 3 жыл бұрын

Glad you liked it, Savio!

@shakeeljaved3181 2 жыл бұрын

Many thanks... Love your videos..

@Tmwyl 9 ай бұрын

Love your videos!

@nadermounir8228 3 жыл бұрын

Great tutorial Leila. Amazing ! 👏

@abijahmaniaco Жыл бұрын

That dynamic data source is next level. 👏🏼 I wish there was a way to dynamically associate underflow and overflow histogram bins to cells calculating outlier thresholds (quartile 1 - 1.5 interquartile range or quartile 3 + 1.5 interquartile range).

@shajupauljohn3244 2 жыл бұрын

Very good, you explain every point in detail.

@skthalange 2 жыл бұрын

It’s just simply mind blowing what you can do with Excel and you explain it in such an engaging and simple to understand manner. Then you even let us download a free workbook. I’ll certainly sign up to a paid for course because it’s going to make me an excel genius

@danfeliciano570 2 жыл бұрын

Great video. Thank you for sharing.

@joeschmoe2659 3 жыл бұрын

I learn so much from up you! Thank you!

@faucillon Жыл бұрын

It has been literal YEARS since I last learned something entirely new about Excel. Don't get me wrong you know your stuff, but I'm reasonably well versed in it too. This video though is a game changer. I'll be including this on my dashboard and squeeze a bit more data out of my screen real estate. 100% on the knowledge, clarity of the explanation and usefulness of the video. Earned my subscription :)

@LeilaGharani Жыл бұрын

That's great to hear. Glad to have you aboard, Thierry!

@luigisir6893 2 жыл бұрын

Well done... spectacular!

@sameermathur9927 Жыл бұрын

Absolutely brilliant tip on Radio buttons

@stoffel1330 2 жыл бұрын

You're honestly way to smart with Excel... I'll be watching more of your videos, they already helped me alot, thank you so much!😂😁

@thailynguyen 3 жыл бұрын

Thanks so much. Awsome trick with SWITCH and clever use of Name

@waresfaisal9305 Жыл бұрын

Superb technique!! Thanks a lot Ms. Leila

@LeilaGharani Жыл бұрын

My pleasure!

@fireman87 2 жыл бұрын

you are amazing, I learn so much from you!

@sarahredmond5366 2 жыл бұрын

Brilliant - thanks so much!

@Tdx-nk3os 3 жыл бұрын

Thanks for showing us creative ways to do stuff in Excel, very inspiring!

@LeilaGharani 3 жыл бұрын

My pleasure!

@samuellazarus1107 3 жыл бұрын

Wow... that's awesome... you make it look so simple.

@chrislow123 3 жыл бұрын

As ever...so useful! Thank you so much 👌🏻

@chrism9037 3 жыл бұрын

That was very cool, thanks Leila!

@marckirsch 2 жыл бұрын

Amazing Vido. I thought I have seen a lot on Excel, but this one it outstanding. Right pace, very well presented. Awesome!

@LeilaGharani 2 жыл бұрын

Glad you liked it, Marc!

@josecarlosconejo5724 3 жыл бұрын

Excellent! Very smart. Hats off 🙌… I really learn a lot here…

@naboulsikhalid7763 3 жыл бұрын

each tutorial is an other level of knowledge. Thank you Leila. PS: my daughter is Leila too

@TongkiNgaceng 2 жыл бұрын

thank you very much for the switch function ,..

@official_utibaba 2 жыл бұрын

Wow! Thank you for this

@theedspage 2 жыл бұрын

Wow! Your videos are wonderful, thank you!

@amaroel 4 ай бұрын

Thank you Leila .... it's another way to present a dashboard and i like it 👍👍👍

@LeilaGharani 4 ай бұрын

You're welcome 😊

@simonkirkebyrasmussen6124 3 жыл бұрын

I love it ! More dynamic and so easy to read/use :-D

@navinraj0107 3 жыл бұрын

This level of knowledge sharing is awesome and thank you

@manuelborgelioen 3 жыл бұрын

Thanks ! You are great !!

@alisonzhang6162 Жыл бұрын

I have been looking for those option buttons forever, thank you so much!

@LeilaGharani Жыл бұрын

Our pleasure!

@robertcortes2315 3 жыл бұрын

too great Miss Leila, I found this very useful, thanks a lot.

@muhdfadillah2343 3 жыл бұрын

Brilliant Microsoft programmer who created this Excell so functionable.we just have to learn how to make use that.

@user-xo1vo8hu1n Жыл бұрын

Gosh.. you make it look so simple.. just simply, awesome!

@PiotrMys 3 жыл бұрын

Wow.. this is badass.. I thought I was good and efficient with Excel but this is so so so elegant!!!

@williamlee8514 2 жыл бұрын

This is extremely cool!

@jeffc5218 3 жыл бұрын

Crazy! will definitely use this one :) thank you Leila

@adrianodossantosfernandes1236 2 жыл бұрын

Thanks Leila! Your videos are amazing and very helpful!

@LeilaGharani 2 жыл бұрын

Glad you think so, Adriano!

@dpu_paul 3 жыл бұрын

Always comes up with smart tips. Thanks a billion😊

@LeilaGharani 3 жыл бұрын

My pleasure!

@ALMorhun 3 жыл бұрын

Leila as always you are the best :) Thank you

@fahadaldossary7949 3 жыл бұрын

You are Amazing Leila !! Many Thanks for the hard work and valuable information 💚🙏

@LeilaGharani 3 жыл бұрын

You're so welcome!

@LauraReyes-yo5nz 3 жыл бұрын

Hi Leila! First thing you are awesome! I love all that you teach and each video makes me more excited about Excel. I'm not always sure how to even ask google the questions so, I can find the video that you have undoubtedly already put out. How do I move the chart to a different page? I don't want all the data to show. I just want people to see the charts while I click through the Option buttons. Preferably in the same workbook. Thanks for your help and for sharing the incredible knowledge you have!

@JYCrazy1 2 жыл бұрын

This is incredible, I’m going to use this so much! I learned INDEX, SWITCH and hashes in this video, super useful formulas which will help massively cut down some of my IF-based formulas :)

@LeilaGharani 2 жыл бұрын

Glad you enjoyed it!

@chinacetacean 2 жыл бұрын

Ciao Jack, I am wondering if this is really a good solution. I wonder why anyone would opt to use radio buttons instead of quick pivots and slicer?