In this video, we'll explore SPARKLINE and REPT & CHAR functions to build a multi-coloured progress bar chart that is linked to a to-do task list. As the status of a task is changed, the progress bar chart will dynamically adjust to display the progress and the percentage completed.
With the SPARKLINE progress bar chart, we'll break this down into separate charts to display the status of each task in its own cell, and its colour is related to the status of the drop-down chip.
With the REPT & CHAR progress bar chart, we'll combine everything into one cell, displaying 4 different task statuses in one progress bar with 4 different colours.
If you haven't seen my related videos on the SPARKLINE and REPT & CHAR functions, you can check these out below, along with the Drop-down chips too.
Related Videos
SPARKLINE Progress Bar Chart https://youtu.be/L2PiOCv65_o
REPT & CHAR Progress Bar Chart https://youtu.be/WurBzQ7HZjk
Drop-down Chips https://youtu.be/Nw_M_OUgNck
Resources
The Unicode HTML codes used for the REPT & CHAR function in this video were:
https://www.compart.com/en/unicode/U+1F7E2 - Green - 128994
https://www.compart.com/en/unicode/U+1F535 - Blue - 128309
https://www.compart.com/en/unicode/U+1F7E1 - Yellow - 128993
https://www.compart.com/en/unicode/U+1F534 - Red - 128308
The SPARKLINE HEX colours used in this video were:
Backlog - f4cccc - red
Not Started - ffe599 - Yellow
In Progress - a4c2f4 - Blue
Completed - b6d7a8 - Green
Outstanding - bdbdbd - Grey (color2)
Chapters
00:28 - Multi-Coloured SPARKLINE Progress Bar Chart
04:56 - Percent Completed Function
06:22 - Multi-Coloured REPT & CHAR Progress Bar Chart
Social Channels
YouTube https://www.youtube.com/@spreadsheetwise
Twitter https://twitter.com/SpreadsheetW
Instagram https://www.instagram.com/spreadsheetwise/
Facebook https://www.facebook.com/spreadsheetwise/
Pinterest https://www.pinterest.co.uk/SpreadsheetWise/
Tags
#GoogleSheetsProgressBar #Progressbar #Spreadsheet #REPT #CHAR #todo #GoogleSheetsTipsAndTricks #GoogleSheetsHacks #googlesheets #googlesheetstutorial #Spreadsheetwise #sparklines