1

I have a training doc on Excel, with multiple sheets, showing multiple tasks that need to be done. On the home page (worksheet) I would like to show a progress bar showing the amount of tasks complete as a percentage. Is this possible? How can I do it?

1 Answer 1

1

Yes, it is definitely possible, take a look:

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.

enter image description here

From the Excel ribbon, select Conditional Formatting and then Data Bars. Next, select More Rules..

enter image description here

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.

enter image description here

f you have adjusted all of the previous settings correctly, you should now see a progress bar.

enter image description here

1
  • @stevehilton You are welcome! Fell free to mark this answer as accepted ;) Jan 13, 2016 at 18:02

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .