This is going to surely impress everyone in office. A crazy simple and powerful dynamic chart with Excel check boxes.

We can use the "Checkbox" form control in Excel to create a stunning chart. The trick is to link your check box to a cell and then build "formulas" to on/off the data. At Awesome Chocolates, we are using it to analyze sales data interactively.

What are you going to use it for? Do tell me in the comments.

IN THIS VIDEO ⏱
================
0:00 Quick demo of the dynamic chart
0:22 Enabling the Developer Ribbon in Excel
1:00 Working with Checkboxes in Excel
2:37 Creating the dynamic checkbox chart
5:57 But the chart "SUCKS" Making it "AWESOME"

Sample file
=============

Need a practice workbook? Use this link to get it https://chandoo.org/wp/wpcontent/upl...

Want more Charts ?
=======================

I recommend watching these videos to learn more Excel Charting & Dashboarding tricks.

Top 5 Chart (to highlight important data points) in Excel    • Create a Top 5 Dynamic Chart with thi...  
Make a traffic light chart for your project reports    • Traffic Light Chart in Excel  PM Das...  
6 Musthave chart tricks for data analysts    • 6 Must have line charts for business ...  
A simple dashboard trick to wow your audience    • Link up two charts to the same slicer...  

My Excel charting playlist
   • Make impressive infographics with sha...  

Learn Excel STEP BY STEP ‍‍:
============================

Do you want to learn Excel for doing advanced data analysis and reporting? If so, you will find my Excel School program perfect for you. It can change the way you use and work in Excel.

Please visit https://chandoo.org/wp/excelschoolp... to sign up for my online class.

~

Why are column charts lazy?
Because they just stand

#Excel #analytics