How to Create a Progress Bar in Excel (Easiest Way in 2025)

In this article, we will show you how to add a progress bar in Excel. Simply follow the steps below.

How to Show a Progress Bar in Excel

To insert a progress bar in Excel, simply follow the process below.

1. Set Up Your Data

First, organize your data. In our example below, we created two columns: one for the task and one for the progress percentage. Fill in the tasks and their respective completion percentages (from 0% to 100%).

2. Insert a Stacked Bar Chart

Highlight the data you’ve just entered. Go to the ‘Insert’ tab in the Excel ribbon and select ‘Bar Chart’. Choose the ‘Stacked Bar’ option from the drop-down menu. This will insert a basic bar chart into your worksheet.

3. Update and Manage Your Progress Bar

As tasks progress, update the percentage values in your data table. The chart will automatically adjust to reflect the new progress levels. This visual representation can help you easily track the completion status of various tasks.

We hope you now have a better understanding of how to create a progress bar in Excel. If you enjoyed this article, you might also like our article on how to show formula bars in Excel or our article on importing data from PDF to Excel.