Create a Progress Bar Chart in Google Sheets

Visualising your progress can be a real motivator to get stuff done. Sparklines and repeat functions can help with that by using Progress Bar Charts in Google Sheets.

To view the full tutorial for creating a Progress Bar Chart in Google Sheets using both the REPT and CHAR functions as well as the SPARKLINE function, check out this link on my website at Spreadsheet Wise.

This is the website I used to get the HTML Unicode characters used in this video.

This is the same Unicode website with a link to the character sets

For more videos and/or to subscribe, check out this link

Social Channels

#GoogleSheetsProgressBar #Progressbar #Spreadsheet #GoogleSheetsTipsAndTricks #GoogleSheetsHacks #googlesheets #googlesheetstutorial #Spreadsheetwise

[JoelNascimento-ok]

Great tips and pretty in-line/straightforward means of getting that done!

[mojsterr]

Thanks, nice video. I was wondering, how did you get the green boxes to stick together? When I do it, there are tiny white spaces in between them. Yours hold on to one another, like a normal progress bar.

[DadaiCafe]

Hiii.. Thank you for this. Can you help me, how can I insert that in my formula? SPARKLINE(E21, {"CHARTTYPE", "BAR";"MAX", 100%;"COLOR1", "RED"}). I'm kinda confused :( and sorry I'm just strating to learned sparkline or progress bar in gogglesheet.

[gouacheink]

Is there any way to include this in the COUNTIF function for a progress bar that responds to checkboxes? I've made a sheet for my assignments and would like to use pink and gray hearts rather than a bar, (right now I just have a color progress bar). The hearts I want to use are 129655 and 129654

[MrPushupp]

what are the codes for red hearts and black hearts?