Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-01-2014, 07:56 AM
Intruder Intruder is offline format color of gantt chart bars based on progress? Windows XP format color of gantt chart bars based on progress? Office 2007
Advanced Beginner
format color of gantt chart bars based on progress?
 
Join Date: Dec 2010
Posts: 59
Intruder is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 02-01-2014, 10:12 AM
JulieS JulieS is offline format color of gantt chart bars based on progress? Windows 7 64bit format color of gantt chart bars based on progress? Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 02-01-2014, 10:21 AM
Intruder Intruder is offline format color of gantt chart bars based on progress? Windows XP format color of gantt chart bars based on progress? Office 2007
Advanced Beginner
format color of gantt chart bars based on progress?
 
Join Date: Dec 2010
Posts: 59
Intruder is on a distinguished road
Default

thanx Sofie, can this be automated or need to do manual ?
Reply With Quote
  #4  
Old 02-01-2014, 10:58 AM
JulieS JulieS is offline format color of gantt chart bars based on progress? Windows 7 64bit format color of gantt chart bars based on progress? Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #5  
Old 02-02-2014, 05:05 AM
Intruder Intruder is offline format color of gantt chart bars based on progress? Windows XP format color of gantt chart bars based on progress? Office 2007
Advanced Beginner
format color of gantt chart bars based on progress?
 
Join Date: Dec 2010
Posts: 59
Intruder is on a distinguished road
Default

ok thanx Julie
Reply With Quote
  #6  
Old 02-02-2014, 07:29 AM
JulieS JulieS is offline format color of gantt chart bars based on progress? Windows 7 64bit format color of gantt chart bars based on progress? Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You're welcome
Reply With Quote
  #7  
Old 02-02-2014, 07:36 AM
Intruder Intruder is offline format color of gantt chart bars based on progress? Windows XP format color of gantt chart bars based on progress? Office 2007
Advanced Beginner
format color of gantt chart bars based on progress?
 
Join Date: Dec 2010
Posts: 59
Intruder is on a distinguished road
Default

for your intrest, I posted a new thread regarding gantt chart bar formatting
u seems to be a specialist ?
Reply With Quote
  #8  
Old 02-02-2014, 01:50 PM
JulieS JulieS is offline format color of gantt chart bars based on progress? Windows 7 64bit format color of gantt chart bars based on progress? Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

yes, thanks. I did see it and answer.
Reply With Quote
Reply

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
format color of gantt chart bars based on progress? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft