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.
Download Practice Workbook
You can download the practice workbook from the download button below.
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.
