Project 2002 Timescale

[Brian]

Two questions: First, I'd like my timescale on the Gantt
chart to have monthly intervals, but only show the
interval lines every three months. Is this possible
because as of now it's either names of each month with
lines for each month or lines every three months with only
January, April, July, and October showing above? Also, is
there a way to sort or possibly filter by Gantt chart bar
colors?

 

[John]

Brian,
If I understand your first request, you would like to show a vertical
line on the Gantt graphic between Dec/Jan, Mar/Apr, etc. Unfortunately
this feature is not available directly. You can emulate the effect but
it will be crude and cumbersome at best. Use the drawing feature to draw
vertical lines where needed. By default the lines will be "attached" to
the timescale.

Sorting or filtering by Gantt Chart bar colors generates a "maybe"
answer. Although it is not directly possible to include bar color as a
sorting or filtering variable, some thought process was used to come up
with the color scheme in the first place. For example, maybe yellow bars
represent tasks that are for software development and green bars are for
hardware built, etc. Knowing the thought process that generated the
color scheme, it is possible to use that information in the sort or
filter (e.g. set various flags for each color and sort/filter on the
flags). If the color scheme is more complex, it should still be possible
to develop an algorithm that can be incorporated into a VBA macro. That
macro could set values for a sort or filter. So I guess, the bottom line
answer is "yes", it can be done.

Hope this helps.
John