Quickly create a progress bar with percentage in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
Usually, we use the progress bar chart to express the how many percentages of a project is completed in Excel. But in general Excel, you need at least 8 steps to create a progress bar, while Kutools for Excel’s Progress Bar Chart utility only needs 3 steps.
Moreover, the Progress Bar Chart supports create progress bar with percentage by using two types of data:
Create progress bar chart based on given progress percentage data
Create progress bar chart based on given actual and target data
Applying this utility by clicking Kutools > Charts > Progress > Progress Bar Chart. See screenshot:
Create progress bar chart based on given progress percentage data
If the data has listed the percentages of each progress, please create the progress bar chart as below steps:
1. Click Kutools > Charts > Progress > Progress Bar Chart.
2. In the popping dialog, click 
to choose the axis labels to the Axis label range, then check Percentage of current completion option in the Current Progress section, then click in the Percentage of current completion section to select the cells containing the percentages.
3. Click OK. Then the progress bar chart has been created.
Create progress bar chart based on given actual and target data
If the data contains actual and target values, to create a progress bar chart with percentages, you can do as below steps.
1. Click Kutools > Charts > Progress > Progress Bar Chart.
2. In the popping dialog, click to choose the axis labels to the Axis label range, check Actual, Target option in the Current Progress section, then click in the Actual and Target sections to separately select the cells containing the actual and target values.
3. Click OK. Then the progress bar chart has been created.
Tip：
1. You can click Example button in the Progress Bar Chart dialog to realize how to use this utility.
2. The chart will be updated based on the data changed.
3. To change the bar color, please click at one of the bars or bar borders in the chart, then under Format tab, choose a new color from Shape Fill or Shape Outline menus as you need.
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
