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

Get FREE Advanced Excel Exercises with Solutions!

This article illustrates how to show the percentage progress bar in Excel. You can use the percentage progress bar to compare the working rates 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.

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

## 1. Creating a Bar Chart to Show Percentage Progress Bar in Excel

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, and 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.

## 2. Showing 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.

## 3. Showing Percentage Progress Bar with Excel 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.

## 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.

Stay with us and keep learning.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , and premium Excel consultancy services for Excel and business users. Feel free to contact us with your Excel projects.
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

Advanced Excel Exercises with Solutions PDF