Create a Progress Bar in Microsoft Excel that Automatically Updates

Microsoft Excel doesn’t have a built-in progress bar, but it’s easy to create one using a bar chart.

In this hands-on tutorial, I’ll show you how to insert a stacked bar chart, restyle it, and then remove chart elements to end up with a polished and professional-looking progress bar. And the best part, it will update automatically when you change the underlying data!

00:00 – Overviewing the completed progress bar in Microsoft Excel
00:14 - Adding rows and columns for the chart
00:49 - Inserting a stacked 100% bar chart
01:29 - Restyling the chart and removing chart elements
03:37 - Testing the completed progress bar

[TinyTechnicalTutorials]

What else do you want to learn in Excel? Let me know below in the comments!

[lindseyhamer]

Great tutorial! Perfect speed for someone who is proficient but not an expert just yet. Thank you!!!

[Masoom]

This is exactly the kind of thing I was looking for. Thank you!

[robertlaskarzewski]

Couldn't find this anywhere else, thank you!

[kroocofortnite]

hello! I tried this but when i introduce a value of more than 85% the progress bar is replaced by anothe progress bar from 85% to 100% which might be confusing.. Is there a way to get the same progress 0-100% bar always the same until it reaches the 100%?

[jeroenstokmans]

Why does my prograss bar not update automatically