Formatting Gantt Summary Bars in a Grouped View

R

RNobleman

I have a task field called "billable department" in many projects. I
have created a master project with a few of these projects, with a
view that groups the data by project and billable department.

The problem I'm having is that I want to color code the billable
department summary bars. I am able to change the color of all of the
Gantt bars manually using the "Bar Styles" option, but not each
individual bar. The same limitation applies to using a macro.

Does anyone have any recommendations about how to accomplish this?

Thanks.
 
J

JulieS

Hi,

Are you trying to do this in Project Professional or Standard or PWA?

Julie

?? wrote in message
news:3c972be0-c54a-4ca7-8af0-57d420c8f523@l33g2000pri.googlegroups.com...
 
R

RNobleman

Hi,

Are you trying to do this in Project Professional or Standard or PWA?

Julie

?? wrote in message








- Show quoted text -

I'm trying to do it in Project Professional, though if it's possible
to do it in PWA, that would work as well.

Rick
 
J

JulieS

Rick wrote in message
- Show quoted text -
I'm trying to do it in Project Professional, though if it's possible
to do it in PWA, that would work as well.

Thanks for the information Rick. Would coloring the individual bars
by the billable department suffice? As you noted, the individual
grouped summary bars cannot be changed through Format > Bar, you can
only change the color for the "Group by Summary" bars.

If color coding the bars by billable department would work in your
scenario, see FAQ #31 "Customizing Task Bars". Although the FAQ
specifically references Project 2000, it is applicable to all releases
beyond that as well. You'll need to make a minor modification to the
formula noted, replacing the field [Resource Names] with the field
you've used to note your billable department information.

I'll leave it to one of the server gurus to discuss whether you can
accomplish grouping and changing in PWA.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project
 
R

RNobleman

Rick wrote in message

<snip>




- Show quoted text -
I'm trying to do it in Project Professional, though if it's possible
to do it in PWA, that would work as well.
Rick

Thanks for the information Rick.  Would coloring the individual bars
by the billable department suffice?  As you noted, the individual
grouped summary bars cannot be changed through Format > Bar, you can
only change the color for the "Group by Summary" bars.

If color coding the bars by billable department would work in your
scenario, see FAQ #31 "Customizing Task Bars".  Although the FAQ
specifically references Project 2000, it is applicable to all releases
beyond that as well.  You'll need to make a minor modification to the
formula noted, replacing the field [Resource Names] with the field
you've used to note your billable department information.

I'll leave it to one of the server gurus to discuss whether you can
accomplish grouping and changing in PWA.

I hope this helps.  Let us know how you get along.

Julie
Project MVP

Visithttp://project.mvps.org/for the FAQs and additional information
about Microsoft Project- Hide quoted text -

- Show quoted text -

Thanks for you note, Julie.

Where is the FAQ you reference? I didn't see it on the
microsoft.public.project.server page.

Thanks,

rick
 
J

Jack Dahlgren

The FAQ is on the Project MVP page. Here is the URL:

http://project.mvps.org/faqs.htm

-Jack Dahlgren

Rick wrote in message

<snip>




I have a task field called "billable department" in many projects.
I
have created a master project with a few of these projects, with a
view that groups the data by project and billable department.
The problem I'm having is that I want to color code the billable
department summary bars. I am able to change the color of all of
the
Gantt bars manually using the "Bar Styles" option, but not each
individual bar. The same limitation applies to using a macro.
Does anyone have any recommendations about how to accomplish this?
Thanks.- Hide quoted text -
- Show quoted text -
I'm trying to do it in Project Professional, though if it's possible
to do it in PWA, that would work as well.
Rick

Thanks for the information Rick. Would coloring the individual bars
by the billable department suffice? As you noted, the individual
grouped summary bars cannot be changed through Format > Bar, you can
only change the color for the "Group by Summary" bars.

If color coding the bars by billable department would work in your
scenario, see FAQ #31 "Customizing Task Bars". Although the FAQ
specifically references Project 2000, it is applicable to all releases
beyond that as well. You'll need to make a minor modification to the
formula noted, replacing the field [Resource Names] with the field
you've used to note your billable department information.

I'll leave it to one of the server gurus to discuss whether you can
accomplish grouping and changing in PWA.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visithttp://project.mvps.org/for the FAQs and additional information
about Microsoft Project- Hide quoted text -

- Show quoted text -

Thanks for you note, Julie.

Where is the FAQ you reference? I didn't see it on the
microsoft.public.project.server page.

Thanks,

rick
 
J

JulieS

Rick wrote in message

<snip>




- Show quoted text -
I'm trying to do it in Project Professional, though if it's
possible
to do it in PWA, that would work as well.
Rick

Thanks for the information Rick. Would coloring the individual bars
by the billable department suffice? As you noted, the individual
grouped summary bars cannot be changed through Format > Bar, you can
only change the color for the "Group by Summary" bars.

If color coding the bars by billable department would work in your
scenario, see FAQ #31 "Customizing Task Bars". Although the FAQ
specifically references Project 2000, it is applicable to all
releases
beyond that as well. You'll need to make a minor modification to the
formula noted, replacing the field [Resource Names] with the field
you've used to note your billable department information.

I'll leave it to one of the server gurus to discuss whether you can
accomplish grouping and changing in PWA.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visithttp://project.mvps.org/for the FAQs and additional information
about Microsoft Project- Hide quoted text -

- Show quoted text -

Thanks for you note, Julie.

Where is the FAQ you reference? I didn't see it on the
microsoft.public.project.server page.

Thanks,

rick

Sorry Rick. Thanks for the catch Jack :)

Julie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top