Sometimes it’s important to create a detailed visual on your Excel data. One of them is a progress bar. Here’s how to create progress bars in Excel the easiest way.
What is a progress bar?
A progress bar on your computer is mainly a graphical interface that visualizes the progress of a computing operation. Like how many file sizes you’ve downloaded using a download manager. But, in today’s blog post, the progress is about your own data so you can track down the progress of any data in Excel.
How to create progress bars in Excel
One of the easiest ways to create a progress bar in Excel is by using conditional formatting. Conditional formatting in Excel is used to implement specific cell formatting based on your own criteria.
We can also use conditional formatting to make a progress bar based on a number or percentage, but doing so using just numbers is a lot easier.
The progress bar would look flat if you use the latest version of Excel in the Microsoft Office suite. It’s because it uses the Windows controls based on which Windows version you’re using. It will be a solid color, but the color can be chosen easily in Excel and you can also switch to gradient instead.
First, you have to create a cell that contains the value of the progress bar. Simply write something from 0 to 100 if you want to create a progress bar based on percentage value (without the ‘%’).
Select the cell then choose Conditional Formatting. Choose Data Bars. Choose More rules.
Select Format all cells based on their values. Make sure you choose Data Bar on “Format Style”. You can enable or disable “Show Bar Only” whether you want to show the progress bar’s value or not.
Choose Number for both Minimum or Maximum. Type 0 and 100 for each value. However, you can customize the way you want it to be for your progress bar.
Choose the color. Choose whether you want it to be a gradient or solid color. Choose whether it will have a border and choose which color it represents. Click OK.
Now, you have made your own progress bar on Excel. It will look like this:
Microsoft Excel allows you to create a progress bar to visualize your data in a better way. Yes, you can put the progress bar’s value automatically based on other cells’ calculations.
Dony Prasetiyo has been writing on monkeymanifesto.com for about two years, intended to help solve computer and smartphone problems with easy-to-understand blog posts. He has written over 480 blog posts about Windows, Office, Android, and more.