Create an Interactive Chart with Checkboxes in Microsoft Excel
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.
Видео Create an Interactive Chart with Checkboxes in Microsoft Excel канала Teacher's Tech
#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.
Видео Create an Interactive Chart with Checkboxes in Microsoft Excel канала Teacher's Tech
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
5 Amazing Google Docs Hacks!Revolutionize Your Guide Creation: Auto-Generate with ScribeHow to use Threadit - Video meetings you don't need to be at!Set Goals in Google Calendar - New FeatureMake Microsoft Excel WAY Smarter?Google Drive Tutorial - Managing DriveRepair Documents in Microsoft Word. Make Old Look New!Relative vs Absolute Cell Reference in Microsoft Excel - What's the difference?Learn Different Ways to Combine Cells in Microsoft ExcelMicrosoft OneNote for Windows 10 Tutorial - Beginner's Level 2Create Drone-Style Videos for FREE with Google Earth StudioHow to Remove a Background from an ImageEasy Podcasting for Teachers and Students with Synth3 Powerful Camera Features with Google App on a iPhoneCreate Excel Pivot Table from Multiple Sheets: The FASTEST WayMail Merge Made Easy: From Excel to Word to OutlookHow to use the XLOOKUP Function in Microsoft Excel - Beginners Tutorial7 Tips in Microsoft Word You May Not Know AboutMicrosoft OneNote for Windows 10 - Tips and TricksCreate a FREE Website with Canva - The Easy Way!