Create a progress bar in Microsoft Excel 2010

When you are showing the progress of anything on Microsoft Excel 2010, did you know that you could actually display the progress in the form of a progress bar? Progressive bars are a better option when you are displaying the progress of multiple items in a table because with just one look, progress bars allow users to compare the progress of various items at once.

Are you wondering about how this is possible? Simple answer – Conditional Formatting feature makes it possible. Let us see in detail on how you can go about doing this task. Enter the range of values that denote the progress, for example 100, 90, 80… and so on. Then select all the values that have been entered.

After you select the values, you need to click on Conditional Formatting which you can find under the ‘Home’ tab on the ribbon. Once you click that, a drop down menu would appear on the screen from where you need to select the option of ‘Data Bars’ and then ‘More Rules’.

A window with formatting rules would appear on the screen where you need to provide the range of the values. Once you give the maximum and the minimum values, and click OK, a progress bar will be displayed on the selected cells.