Let's Make a Progress Bar

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.

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...

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 progre...

Intermediate

COUNTIF() MAX() SPARKLINE() TRUE()