In this mini course from Better Sheets, we're gonna make a Progress Bar. Sounds simple right? Not so simple for everyone. Progress Bars aren't just for Democrats to drink at. They serve as a visual aid to our data. They can bring gamification to your sheets. And make your data look neat. In 33 minutes across 4 videos, walk with me as we create Progress Bars both horizontally and vertically.
4 Tutorials
Create a Progress Bar - Make Progress Bars with Sparkline: Part 1
Let's make a progress bar in Google Sheets.
SPARKLINE()
Hide Completed Bars - Make Progress Bars with Sparkline: Part 2
Use the IF() formula to hide completed bars and display messages instead of bars depending on the situation.
Make Vertical Bars - Make Progress Bars with Sparkline: Part 3
we're gonna go through what does it take to make a vertical progress bar.
Make Color Changing Progress Bars - Make Progress Bars with Sparkline: Part 4
Create awesome progress bars with sparkline formula. You can make progress bar colors can change based on the input.
MAX()
SPARKLINE()
TRUE()
COUNTIF()