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

Discover how to switch between charts in Microsoft Excel using radio buttons! This simple yet powerful trick is perfect for crafting interactive dashboards.

✅ 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.

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

🚩Let’s connect on social:

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

[EliotPowell]

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

[kristoferbrown]

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

[excel_along_the_way]

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.

[kyleutuber]

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!

[vasistreddy]

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!

[Meanna]

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

[damlayldz]

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

[nairobi]

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

[shashankshekhar]

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.

[TylerStanczak]

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

[ArticulateDesignASMR]

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

[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!

[davidk]

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

[skthalange]

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

[aperkinsvt]

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

[mirkowilhelm]

simply perfect - your teaching skills are great - thank you

[Dubai]

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!

[eliasmeez]

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.

[nyashadzashemandizera]

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 ;)

[ricardoromo]

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!!