In this Excel tutorial, I will show you how to use checkboxes to create an interactive chart. Adding checkboxes in Microsoft Excel can be done by adding the Developer tab, then you will where you can add checkboxes in Excel. After the checkboxes are added you can create a simple IF statement to make it connect to the data you want to chart.

#DubbedWithAloud

0:00 Introduction
1:04 Add the Developer tab
1:59 Add checkboxes in Excel
2:28 Customize the checkbox
3:35 Link cells to your checkbox
4:32 Copying checkboxes
6:00 Starting the interactive chart
6:33 Creating an IF statement to connect to checkboxes
8:24 Inserting a combo chart
9:57 Customizing the chart
12:26 Hiding the TRUE and FALSE display

Access the practice file: https://leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/EQaRHKEq7xFBgQ9mJnj37W8BD9HYU4AmClW2YRWgfWSPiw?e=gbjWnA

More Microsoft Excel tutorials here: https://youtube.com/playlist?list=PLmkaw6oRnRv8lAKbKbflJRqS-9wuYNWUw


English
This video has been dubbed into Spanish (United States) using an artificial voice via https://aloud.area120.google.com to increase accessibility. You can change the audio track language in the Settings menu.

Spanish
Este video ha sido doblado al español con voz artificial con https://aloud.area120.google.com para aumentar la accesibilidad. Puede cambiar el idioma de la pista de audio en el menú Configuración.

Portuguese
Este vídeo foi dublado para o português usando uma voz artificial via https://aloud.area120.google.com para melhorar sua acessibilidade. Você pode alterar o idioma do áudio no menu Configurações.