Quickly create a progress bar with percentage in Excel

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.
shot progress bar chart 7

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:
shot progress bar chart 1


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 shot selectto choose the axis labels to the Axis label range, then check Percentage of current completion option in the Current Progress section, then click shot selectin the Percentage of current completion section to select the cells containing the percentages.
shot progress bar chart 2

3. Click OK. Then the progress bar chart has been created.
shot progress bar chart 3


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 shot selectto choose the axis labels to the Axis label range, check Actual, Target option in the Current Progress section, then click shot selectin the Actual and Target sections to separately select the cells containing the actual and target values.
shot progress bar chart 4

3. Click OK. Then the progress bar chart has been created.
shot progress bar chart 5

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.
shot progress bar chart 6


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.