How to Show Percentage Progress Bar in Excel (3 Suitable Ways)

This article illustrates how to show the percentage progress bar in excel. You can use the percentage progress bar to compare the working rate of different teams, quickly track the status of different tasks, and so on. A progress bar is a very powerful graphic in the sense that it enables us to understand the information instantly. Follow the article to learn how to create a percentage progress bar in excel.


Download Practice Workbook

You can download the practice workbook from the download button below.


3 Ways to Show Percentage Progress Bar in Excel

Assume you have the following dataset. Now you want to show the progress percentage with the progress bar. Then follow the methods below.


1. Show Percentage Progress Bar with a Bar Chart

You can show the percentage progress bar by inserting a Bar Chart in excel. Follow the steps below to do that.

πŸ“Œ Steps

  • First, enter the following formula in cell D5. Then, drag the fill handle icon to copy the formula down to the cells below.

  • Next, keep any cell within the data range selected. Then, select Insert Column or Bar Chart from the Insert Now, choose the 100% Stacked Bar from the 2-D Bar list.

  • After that, the following chart will be inserted.

  • Finally, edit the Bar Chart with proper design and formatting to get the following result.

show percentage progress bar in excel

Read More: How to Make Progress Chart in Excel (2 Simple Methods)


Similar Readings


2. Show Percentage Progress Bar with Data Bars

You can also show the percentage progress with Data Bars. Follow the steps below to do that.

πŸ“Œ Steps

  • First, select the entire range (C5:C10) containing the progress percentages.
  • Then, select Conditional Formatting >> Data Bars from the Home tab.
  • Next, choose the fill color for the progress bar from the Gradient Fill or Solid Fill options.

  • After that, make the texts left-aligned to get the following result.

show percentage progress bar in excel

Read More: Progress Bar in Excel Cells Using Conditional Formatting


3. Show Percentage Progress Bar with REPT Function

Alternatively, you can manipulate the REPT function to show the percentage progress bar in excel. Follow the steps below to do that.

πŸ“Œ Steps

  • First, select cell D5.
  • Then, change the font to Playbill from the Home tab.
  • Next, choose the top and left alignments for the cell.
  • After that, select a fill color for the cell.
  • Now, enter the following formula in that cell.
=REPT("|",C5*100)
  • Then, drag the fill handle icon to copy the formula to the cells below.
  • Finally, you will get the following result.

show percentage progress bar in excel

Read More: How to Create Progress Bar Based on Another Cell in Excel (2 Easy Ways)


Things to Remember

  • You need to click on the Bart Chart to be able to customize it as required.
  • You can also apply the data bars to the cells by adding a new conditional formatting rule.

Conclusion

Now you know how to show the percentage progress bar in excel. Do you have any further queries or suggestions? Please let us know using the comment section below. You can also visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo