Waffle Chart In Excel - Excel Tips and Tricks Let me show you how I can create a waffle chart in Excel. Here's the formula feature in my video. Numbering =SEQUENCE(10,10,0.01,0.01) For Microsoft 1) Select F7 2) Conditional Formatting ~ Manage Rule 3) New Rule... 4) Format only cells that contain 5) Cell value, Less than or equal to, =$D$6 6) Format 7) Fill tab 8) Color = Blue 9) OK 10) OK For Google And Apple 1) New Rule... 2) Format only cells that contain 3) Cell value, Less than or equal to,

Here's what a typical Excel dashboard or reporting project looks like from someone that does this for a living. I've simplified this as much as I can to make it accessible and understandable. It should be useful for just about anyone going through a project in Excel - whether you're building dashboards or just cleaning up a funky CSV file. #Excel #exceltutorial #microsoftambassador #betterspreadsheets

Excel Basics 5: PivotTable Power to Create Reports with Various Calculations & Layouts

Advanced Excel Tips: How to Create a Dynamic PivotTable Style Report with One Formula

Subtraction in Microsoft Excel

How to use the IF function in Excel