excel 2007 project/milestone progess bar

Question

I want to display project progress in Excel 2007. Is there a way to show a progress bar like filled for completed percentage and empty until end date for a milestone or the whole project. It seems I cannot find this functionality.

best, USP

Answer 1

If you don't mind a text representation and you have your % value in cell A1, you can use:

=REPT(".",A1*50)&TEXT(A1,"0%")&REPT(".",(1-A1)*50)

This will give you results like:

0%..................................................
.....10%.............................................
..........20%........................................
...............30%...................................
....................40%..............................
.........................50%.........................
..............................60%....................
...................................70%...............
........................................80%.........
.............................................90%....
..................................................100%

You can change the hard-coded value of 50 lower/higher to give less/more granularity.

You'll get best results using a fixed width font.