Radio buttons or Option buttons in Microsoft Excel are a great way to add interactivity. 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.

Timestamps

• 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

#excel