Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Mark up progress - Urgent

10 replies [Last post]
Wed, 2008-10-15 10:57
Bill Joshaf
User offline. Last seen 15 years 6 weeks ago. Offline
Joined: 26 Jun 2005
Posts: 33
Groups: None
Hi Experts,

How can I show progress in different colours at three different dates on one bar in MS Project .

SupposeProgress of Activity 1 :

a) At 06/10, complete 60% , to be shown in pink

b) At 13 /10, complete 30%, to be shown in green

c) At 15 /10 complete 30 show in red

Please advise the best method for above Its urgent.

Thanks,
Top

Replies

Fri, 2008-10-24 08:44
#1
Bo Johnsen
User offline. Last seen 8 years 49 weeks ago. Offline
Joined: 28 Feb 2006
Posts: 119
Groups: Building Information Modelling, Civil Engineering
Bill,

One simple way you could do something similar without flags or anything "tricky" is as follows:

Add e.g. columns "Finish 1" for 30%, "Finish 2" for 60% and "Finish 3" for 90%. Leave them blank. Then in Bar Styles under the normal row for Progress add these 3 rows, but just in reverse order, i.e. first the bar style for 90% from actual start to finish 3, then for 60% and last 30%, all to be drawn in row 1. Apply colours and text as you prefer.

On the date you are 30% complete you write that date into "Finish 1" and so on for the activity in question. Actual progress (%) you can still write in as you normally do, however, it will only show if higher than 30%, 60% and 90% respectively.

The above is valid for actual progress. If you wanted for planned progress, you probably need to follow the way Alexandre and Andrew have suggested.

Regards,

Bo
Top
Thu, 2008-10-16 10:12
#2
Andrew Owenson
User offline. Last seen 1 year 41 weeks ago. Offline
Joined: 18 Jun 2008
Posts: 68
Groups: None
Alexandre

I absolutely agree with you. I have treated this as an excercise in graphics only. MSP has adequate facilities for properly reporting progress. However, this might be used as an as built presentation, ie as a one off to represent % value across the project at different time slices shown on one bar. My main interest was to see how you could colour up different sections of a bar at the same time.

Many Regards

Andrew
Top
Thu, 2008-10-16 09:45
#3
Andrew Owenson
User offline. Last seen 1 year 41 weeks ago. Offline
Joined: 18 Jun 2008
Posts: 68
Groups: None
Alexandre

or create a set of flag bars representing each % with a colour of choice. Each flag relative to a different start and finsh number Start1, Finish1 etc. Then on the bar you select the flag and input the new start and finish date for each section(%). As you rightly said each subsequent bar will overwrite the previous. You could go even further and add further text columns and add 30% etc.. to them and in the flag bar add the relevant text column inside the bar. Looks good but takes a long time. Im tired and I need a liedown now !!

Regards

Andrew
Top
Thu, 2008-10-16 09:02
#4
Andrew Owenson
User offline. Last seen 1 year 41 weeks ago. Offline
Joined: 18 Jun 2008
Posts: 68
Groups: None
Alexandre

Do not apologise, the fact that you can communicate in two languages so well puts me to shame. I have tried your formula, basically you are using the % complete to turn the flags on and off. I do not think that is what Bill meant. I think he wanted the first 30% of the bar to be pink on a certain date then the 60% to be green, ie in a 9 day activity the first 3 days to be pink and the following three days (6) to be green. I didnt think you could do that with MSP, which was why I was so interested in your post.

Regards

Andrew
Top
Thu, 2008-10-16 08:40
#5
Andrew Owenson
User offline. Last seen 1 year 41 weeks ago. Offline
Joined: 18 Jun 2008
Posts: 68
Groups: None
Alexandre

Cannot speak for Bill, but I do not quite understand the process.I did tools,customize,fields, task fields but there are no types called Indicators. I am using 2003.

Regards

Andrew
Top