Quickly create an alternative progress bar chart in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
Let’s say you have a set of percentages showing the progresses made towards a same goal, to create a progress bar chart with the percentages data in Excel, you can use Kutools for Excel’s Alternative Progress Bar Chart. With this type of chart, you can easily compare multiple tasks or projects at once, and display their different completion status.
Quickly Create Alternative Progress Bar Chart
To create an alternative progress bar chart with Kutools for Excel according to the percentages data in your Excel, please do as follows:
1. Click Kutools > Charts > Progress > Alternative Progress Bar Chart. See screenshot:
2. In the pop-up Alternative Progress Bar Chart dialog box, click the range-selection button 
to specify the cell ranges of axis labels and series values (percentages) respectively.
√ Note: If you are not sure how to use the utility, please click the Example button, which will open a new workbook that contains a sample dataset and concrete operation to create an alternative progress bar chart.
3. Click Ok, the alternative progress bar chart will be created at once.
4. (Optional) You can click the buttons to the right side of the chart to make it better suit your needs:
- Click the
button to add, remove or change chart elements such as the title, legend, gridlines, etc. - Click the
button to set a style and color scheme for your chart. - Click the
button to filter what data points or names are visible on your chart.
button to add, remove or change chart elements such as the title, legend, gridlines, etc.
button to set a style and color scheme for your chart.
button to filter what data points or names are visible on your chart.Things to know:
1. If you make updates in the source table, you will see the changes reflected in the chart. However, if you change the source data greatly, say, delete rows or columns from the source table, or add rows in between the data range, the chart may not display correctly. You’d better recreate it again.
2. If the axis labels range is adjacent to the series values range in your table, and the range is a one-column or one-row range, instead of selecting the two ranges respectively with the button, you can just select the both ranges without headers, then apply the Alternative Progress Bar Chart feature, the ranges will be automatically filled in.
3. You can move, delete or adjust the size of the elements on your charts as you need after clicking on them.
4. If a label value has over 11 characters (including 11), no ovals will be added to all the labels in the chart.
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.
