Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

I used conditional formatting to get the following, but am not satisfied:

conditional formatting version

The number stands for percentage.

I made another example where the number now stands for the completed percentage of a project. If a milestone is passed it should be colored. Milestones should be passed on a certain date or period.

milestone version

share|improve this question
    
Just trying to clarify your question, you are happy with the data bar type of conditional formatting where the cell is a task and has a percentage complete. What you would like to do though is change the conditional formatting for a milestone to go from no fill before the milestone to all filled once the milestone has passed? If I'm correct with this, can you clarify what the number in the milestone cell represents? –  Ian Turner May 24 '11 at 9:56
add comment

1 Answer

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.

share|improve this answer
    
I tried this. Am note sure but thx anyway. –  user48604 May 24 '11 at 12:45
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.