How to Turn Percentages Into a Progress Bar in Google Sheets

0:00 How to turn percentages into a progress bar . This is a percentage, this is actually the percentage of the year that's passed. 7. 95 percent of the year has passed. We want a little progress bar here. We want to show a visual representation of this number . We're going to use Sparkline and a little bit of spreadsheet design. So our data is just going to be the reference of the number . This could literally be the number in here, but we're just referencing B1 which has the data in it. Comma, and our options is going to be in curly brackets. We're going to say chart type, comma, bar, and then we need a semicolon, and we need max. This is the minimum of what we need. Create a Progress Bar - Make Progress Bars with Sparkline: Part 1 Word Tracker and Progress Tracker in Google Sheets Week Progress Bar

0:45 In percentages, our max is going to be one. If we just hit enter, this doesn't really look like a progress bar . If I hover over it, maybe, because as this number goes higher and higher, it'll fill this cell more and more. So, we've turned off gridlines here, but let's add a gridline or a border around this so that we can actually see where this cell ends. So we're gonna go over here to borders, and I'm gonna choose actually a thicker border than normal. And I'm going to do all the outer one. There it is. And so now, wherever I am with the cursor, I can see how far, or visualize how far this is filled. And if I want to change this color, that's simple as well. Go into our options here for sparkline , add a semicolon, and Make Vertical Bars - Make Progress Bars with Sparkline: Part 3 Word Tracker and Progress Tracker in Google Sheets Start Sheeting Better in 2026

1:36 use color 1, in quotes, comma, and we're going to add a color here. So let's say it's green. And there, it changes the color from orange to green. Maybe we want red. Maybe it's a percentage that is bad. There's red. We can also change the border color . If we want it to denote bad or good, let's change this to red as well. Or if this is a good percentage or even has no affiliation, maybe we want blue, and we want our border to be blue as well. Click there and there. Nice blue progress bar that visualizes that percentage. If you're looking to get more out of Google Sheets than you ever have before, automations, formulas, absolute magic inside of Sheets, you want to learn it all, subscribe here on YouTube to BetterSheets. Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets Google Sheets Green Color Hex Code Brighten Up Your Checklist Automatically Sheet Styles