Multi-Coloured Progress Bar Chart in Google Sheets

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    • Sparkline Progress Bar Chart in Googl...  
REPT & CHAR Progress Bar Chart    • Create a Progress Bar Chart in Google...  
Drop-down Chips    • Drop-down Chips in Google Sheets  

Resources
The Unicode HTML codes used for the REPT & CHAR function in this video were:

https://www.compart.com/en/unicode/U+... - Green - 128994
https://www.compart.com/en/unicode/U+... - Blue - 128309
https://www.compart.com/en/unicode/U+... - Yellow - 128993
https://www.compart.com/en/unicode/U+... - 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    / @spreadsheetwise  
Twitter   / spreadsheetw  
Instagram   / spreadsheetwise  
Facebook   / spreadsheetwise  
Pinterest https://www.pinterest.co.uk/Spreadshe...

Tags
#GoogleSheetsProgressBar #Progressbar #Spreadsheet #REPT #CHAR #todo #GoogleSheetsTipsAndTricks #GoogleSheetsHacks #googlesheets #googlesheetstutorial #Spreadsheetwise #sparklines