#1
|
|||
|
|||
format color of gantt chart bars based on progress?
Task, summary.. bars can be formatted regarding shapem text and color.
I formatted my task/summary bars in blue, when finished they turn red. 'Finished' means when I put them manually on 100% complete. Is there a way the bars are colored automatically red based on the progress compared with the current date rather than setting them manually to x% complete ? thanx roland |
#2
|
|||
|
|||
Project will not automatically mark a task 100% complete based upon the current date. Use the Update Project command to mark tasks complete based upon their expected schedule.
|
#3
|
|||
|
|||
thanx Sofie, can this be automated or need to do manual ?
|
#4
|
|||
|
|||
Sofie?
The Update Project command will update all tasks in the project that were scheduled to be finished by the Status date. I would not suggest automating any any further than the 3 clicks required. |
#5
|
|||
|
|||
ok thanx Julie
|
#6
|
|||
|
|||
You're welcome
|
#7
|
|||
|
|||
for your intrest, I posted a new thread regarding gantt chart bar formatting
u seems to be a specialist ? |
#8
|
|||
|
|||
yes, thanks. I did see it and answer.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data Bars(Progress bar) | teza2k06 | Excel | 0 | 01-30-2014 11:59 AM |
How can I count cells based on their fill color that was set by conditional format | trueimage | Excel Programming | 1 | 10-25-2013 12:08 PM |
Bar in the Gantt chart with the duration | ms_user | Project | 3 | 01-11-2013 06:31 AM |
Can two sets of task bars be shown on the Gantt? | steve@stanley | Project | 1 | 07-23-2012 06:03 AM |
gantt bars with text and i'm losing the bar when i print | oompa_l | Project | 0 | 11-17-2010 01:16 PM |