Discover I can create a progress tracker with animated image in Excel. <br />I will not be using an animated gif in cell, but use logical IF to shuffle the image. I will be using checkbox to replace traditional progress bar for project tracking and habit tracking. Did I day this can be used for habit tracking too? <br /><br />Here are the steps as outlined on this video. <br /><br />Enable Developer Ribbon <br />1) Right-click anywhere in the ribbon <br />2) Customized the Ribbon... <br />3) Check on Developer <br />4) OK <br /><br />Add Checkboxes <br />1) Developer ~ Controls <br />2) Insert ~ Form Controls ~ Check Box <br />3) Right-click ~ Edit Text <br />4) Delete text <br />5) Right-click ~ Format Control <br />6) Cell Link A2 <br />7) OK <br />8) Repeat steps 2 to 7 for all rows <br />9) Check all checkboxes <br />10) Change cell font to white. <br /><br />I recently posted a video on how you can make an animated habit tracker using Google sheet like this. <br />But a few of my subscribers were requesting if I can do the same thing in Microsoft Office. <br />So... I just have to try it. And this is how you can do it. <br /><br />After that, we're going to place a check on every check box and change the font colour of the cell to white. <br /><br />Just note that your loader index boundary might be different than mine. <br /><br />In the next part we will finish off this tips and tricks... stay tuned. <br />Calculations <br />1) Count completed task <br /> =COUNTIF(B2:B21,TRUE) <br />2) Count incomplete task <br /> =COUNTIF(B2:B21,FALSE) <br />3) Percentage completed <br /> =B25/SUM(B25:B26) <br />4) Loader Index <br />=IF(B27=1,5,""))))) <br />Note these are my boundaries <br />=1 <br /><br />Image Repo <br />1) New Sheet <br />2) Enter 1 to 5 on rows A1 to A5 <br />3) Adjust height of the row <br />4) Select B1 <br />5) Insert ~ Pictures ~ This Device <br />6) Select picture <br />7) Insert <br />8) Repeat steps 4 to 7 to add the remaining pictures <br /><br />Import Image <br />1) Ctrl+C on any picture <br />2) Go to main sheet <br />3) Change height of row 23 <br />4) Select cell B23 <br />5) Ctrl+V <br />Animation <br />1) Formulas ~ Define Name <br />2) Set Name to "GROW" <br />3) Refer to as <br /> =XLOOKUP(186!$B$28,186_IMG!$A$1:$A$5,186_IMG!$B$1:$B$5) <br /> =XLOOKUP(HabitTracker001_IMG!,HabitTracker001_IMG!$A$1:$A$5,HabitTracker001_IMG!$B$1:$B$5) <br />For older Microsoft Office <br /> =INDEX(186_IMG!$B$1:$B$5, MATCH(186!$B$28,186_IMG!$A$1:$A$5,0)) <br />In this formula: <br />Cells $B$1:$B$5 contain the plant image <br />Cell $B$28 is Loader Index value <br />Cells $A$1:$A$5 contains list of Loader Index <br />4) OK <br />5) Select plant image <br />6) Change address in the formula bar to =GROW <br />7) Enter <br /><br /> =XLOOKUP(186!$F$12,186_IMG!$A$1:$A$5,186_IMG!$B$1:$B$5) <br />For older Microsoft Office <br /><br /><br />🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗 <br />Progress tracker with animated image in Google Sheet - Excel Tips and Tricks <br />https://youtube.com/shorts/k8KUQpFRB-k <br /><br />Progress tracker with animated image in Excel - PART 1 - Excel Tips and Tricks <br />https://youtube.com/shorts/GLivi0ERyzg?feature=share <br />Progress tracker with animated image in Excel - PART 2 - Excel Tips and Tricks <br />https://youtube.com/shorts/KMqXmr5hCNA?feature=share
