Re: task bar conditioned on resource assignment by Trevor
Trevor
Sat Mar 15 22:35:06 CDT 2008
You can.
Use a spare Flag field with a formula (Tools, Customize Fields) something
like IIF([Resource Names] ="bob",yes,no)
Then in Format, Bar Styles make a Bar Style.
The columns in Bar Styles are:
Name, Appearance, Show For ... Tasks
Name can be whatever you want to appear in the Legend when you print.
Appearance is as you define it.
Show For ... Tasks is "Normal,Flag1"
and the From and To are the same as for Normal Tasks
MSP reads the Styles from top to bottom, so entries further down the list
will over-write entries higher in the list, so your new Style should be
lower than the other Normal Bar Styles... er, actually it won't matter in
this case.
This works if there is only one Resource per Task and it is the same
Resource.
It's not harder, but trickier if you have more Resources and more than one
Resource per Task.
You have to use more Flags, one for each colour, and you only have 14
colours even if you have many more possible appearances.
This is one of those things in MSP that are easy enough to do if you have
spare time, and are good exercise for the practice, but they are really just
cosmetic and take a bit of work and do you really want to do it, because
where's the big benefit, other than showing off?
If you do it, don't do it in the regular Gantt Chart View because then you
lose the usual Critical Path formatting.
Copy the Gantt Chart View, give the copy a name such as "AA Resource Bars
Gantt" and keep the original Gantt Chart formatting as close as possible to
the original, get it back from the Global Template if it is already very
much changed.
Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
www.perfectproject.com.au
"rexepic" <rexepic@discussions.microsoft.com> wrote in message
news:EB13BF73-F021-4A4E-965D-7F51785ADDFC@microsoft.com...
>I want to format appearance of task bar depending upon Resource assignment.