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

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

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

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

[Vedic-Care]

This is helpful, I was searching for it. Thanks for the tutorial.

[mylife]

This was really helpfull, thank you! But how do you get the bar to fill up three rows?

[HuyềnTrangVera]

Hi, I hope that you may reply my concern about how to Add Icon Indicators On Bar Charts in google sheet.
Looking forward to hearing from your answer.