Excel 2013: Create Progress Bars
Posted December 26, 2012 by Alex Bahdanovich in Microsoft Excel
Using Excel 2013’s conditional formatting features, you can create progress bars on your spreadsheets. Progress bars are used to graphically represent the advancement of the data. Essentially, you get a chart-like effect within the rows and cells themselves.
Below is an example of the setup that you should have before you start. I will use Cold/Hot as my demonstration. I also stretched the E cell to make the progress bar longer. This is done to see a more accurate bar, but this step is not a requirement. As you can see, I put the number 12 in the progress bar cell. This number will be the percentage of the bar that is shaded.
From the Excel ribbon, select Conditional Formatting and then Data Bars. Next, select More Rules..
Now, you should see a window which will allow you to create a new formatting rule. For this step, we want to adjust the settings as follows:
Type: Chose Number, both Minimum and Maximum.
Value: Set the Minimum value to 1 and the Maximum value to 100.
Finally, chose your color, and click OK.
If you have adjusted all of the previous settings correctly, you should now see a progress bar.
Below are some examples with various values.
About Alex Bahdanovich
View more articles by Alex Bahdanovich
The Conversation
Follow the reactions below and share your own thoughts.