How to Create Progress Bars in Google Sheets (Step-by-Step)


This step-by-step tutorial explains how to create the following progress bars in Google Sheets:

progress bars in Google Sheets

Step 1: Enter the Data

First, let’s enter some data that shows the progress percentage for 10 different tasks:

Step 2: Add the Progress Bars

Next, type the following formula into cell C2 to create a progress bar for the first task:

=SPARKLINE(B2,{"charttype","bar";"max",1;"min",0;"color1","green"})

Copy and paste this formula down to every remaining cell in column C:

The length of each progress bar in column C reflects the percentage value in column B.

Step 3: Format the Progress Bars (Optional)

You can modify the progress bars to display specific colors based on the progress percentage.

For example, you can use the following formula to display a green progress bar if the percentage is greater than 70, else a yellow progress bar if the percentage is greater than 50, else a red progress bar:

=SPARKLINE(B2,{"charttype","bar";"max",1;"min",0;"color1",IF(B2>0.7,"green",IF(B2>0.5,"yellow","red"))})

The following screenshot shows how to use this formula in practice:

The color of the progress bar is now dependent on the value in column B.

Feel free to add a border around the cells and increase the length and width of the cells to make the progress bars larger and easier to read:

progress bars in Google Sheets

Additional Resources

The following tutorials explain how to create other common visualizations in Google Sheets:

How to Plot Multiple Lines in Google Sheets
How to Create an Area Chart in Google Sheets
How to Create a Gauge Chart in Google Sheets

Leave a Reply

Your email address will not be published.