HomeMicrosoft OfficeMicrosoft ExcelExcel 2013: Create Progress Bars

Excel 2013: Create Progress Bars

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 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.

Alex Bahdanovich
Alex Bahdanovich
Writer, author, wordsmith -- this tech enthusiast enjoys Starbucks, good reads, and golden retrievers.
RELATED ARTICLES

2 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android