How to Create Progress Bars in Google Sheets 

How to Create Progress Bars in Google Sheets 
Reading Time: 5 minutes

Progress bars in Google Sheets are one of the best ways to keep track of your performance, by looking at the easy-to-interpret charts. Whether you are a student wanting to track your progress while preparing for your exams, or you are a team manager, keeping a track of your team’s progress, learning how to create Progress Bars can prove to be useful for you.  

But, Google Sheets does not provide you with a direct way to create Progress Bars but we found a super-easy way for you to create the charts with the least amount of effort. By the end of this article, you’ll learn everything about how to create progress charts in Google Sheets using the SPARKLINE Function.

Before that, let’s get a better understanding of the Progress Bars.

What is a Progress Bar?

A percentage progress bar is a visual representation of the percentage of progress made in bar graph format. The visualization further aids you with effortless tracking of performance. 

Basically, Progress Bars describes how much percentage of a task has been completed, but visually.

Progress Bars in Google Sheets - Visual representation
Figure 1: Progress Bars in Google Sheets

Why a Progress Bar in Google Sheets?

Now, even though Progress Bars function is not in-built in Google Sheets, still learning how to create Progress Bars in Google Sheets can be beneficial.

  • To analyze the data in an easier manner
  • Helps with quick decision making

This being established that Progress Bars in Google Sheets are very helpful, let’s move on to next part now.

How to create a Progress Bar in Google Sheets?

Creating Progress Bars in Google Sheets can be achieved by following a quite straightforward 3-step process.

You can also make a copy of the spreadsheet below to get a hands-on experience.

Sample Spreadsheet for Hands-on Experience

Here, we use the SPARKLINE Function to create the Progress Bars. The SPARKLINE Function uses the value of the field, along with choice of color to depict the percentage. The function fills the cell with the color with respect to the value of the field selected and the maximum and minimum values for the given data.

Note: The max and min values will be 1, 0 respectively in case of percentage.

Syntax for SPARKLINE Function

=SPARKLINE(data, [options])

Where, Data refers to the fields you want the Progress Bars for, and 

Options refers to specifying various parameters such as charttype, color, max and min values. 

For a better understanding of the SPARKLINE Function, you can also refer to the video link.

Step 1: Add the Data to Google Sheets

To get started with the Progress Bars in Google Sheets, you’ll firstly need to add the data to the sheet.

Data to create Progress Bars in Google Sheets
Figure 2: Data to create Progress Bars in Google Sheets

Step 2: Add SPARKLINE Function Syntax to create Progress Bars

Next, you need to add the following SPARKLINE Function Syntax in the cell C3:

=SPARKLINE(B3,{“charttype”, “bar”; “max”, 1; “min”, 0; “color1”, “purple”})

Using the SPARKLINE Function Syntax to create Progress Bars in Google Sheets
Figure 3: Using SPARKLINE Function to create Progress Bars in Google Sheets

Next, you need to copy the same or simply drag the tab for the rest of the rows as shown.

Video 1: Applying SPARKLINE Function to all the rows to create Progress Bars in Google Sheets

The final result for the Progress Bars in Google Sheets will look like this.

Final view of Progress Bars in Google Sheets
Figure 4: Final view of Progress Bars in Google Sheets

Step 3: Format the Progress Bars using IF Function (Optional)

You can also format the Progress Bars according to your convenience to get an even better idea of the data. This can be done using the IF Function while creating the Progress Bars in Google Sheets. You can modify the Progress Bars in such a way so that the Bars are represented in different colors if the value in the field is above/below a particular limit.

For example, look at the Syntax below:

=SPARKLINE(B3,{“charttype”, “bar”; “max”, 1; “min”, 0; “color1”, IF(B3>0.6, “purple”, IF(B3>0.25, “orange”, “yellow”))})

Using IF Function to add formatting to the Progress Bars in Google Sheets
Figure 5: Using IF Function to add formatting to the Progress Bars in Google Sheets

This refers to the condition that if the value in the field is more than 0.6, the color of the progress bar should be purple, if the value is between 0.25 to 0.6, then orange, else yellow.

Next, drag and copy the Syntax for all the rows as shown below.

Video 2: Using IF Function to format all the Progress Bars in Google Sheets

Step 4: View the Progress Bars

The Progress Bars in Google Sheets would finally look like this after adding the IF Function conditions to it.

Final View of Progress Bars in Google Sheets post formatting
Figure 6: Final View of Progress Bars in Google Sheets post formatting

Conclusion

Keeping a track of your progress towards an objective is a really important and crucial task, and Progress Bars can help decrease your effort and time by providing you with easy visuals.

Hope this article helped you!

See Also

Want to know more formulas and functions in Google Sheets? Look at our definitive guide on Google Sheets which covers hundreds of such topics here. Enjoy reading!

How to Create Funnel Charts in Google Sheets: Learn how to create funnel charts in Google Sheets in 4 easy steps

How to select all Checkbox in Google Sheets: Learn how to create a Select All Checkbox in Google Sheets.

How to Use XLOOKUP Function in Google Sheets: Learn how to use XLOOKUP Function in Google Sheets in 3 different ways.

How to Use the CHOOSE Function in Google Sheets: Learn how to use the CHOOSE Function in Google Sheets in 4 minutes using different examples.

One response to “How to Create Progress Bars in Google Sheets 

Leave a Reply