Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Create an Interactive Chart with Checkboxes in Microsoft Excel
Play lesson

Excel for Beginners: Easy Steps to Get Started - Create an Interactive Chart with Checkboxes in Microsoft Excel

5.0 (3)
22 learners

What you'll learn

This course includes

  • 14.5 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

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.

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere