drawing a line or lines vertically down a gantt chart

[pipmonck]

I have a medium sized plan 600 lines, section by country (typically 50
lines per country), and with many milestones, some of which are key.
I want to draw a line to show for each section the date that the
section needs to finish, ( something similar to the status line ) but
in a single plan it will be different for each section. i have used
the date10 field and identified the date by which key activities
should be completed by, but i cant draw a vertical bar, any
suggestions ??

 

[John]

I have a medium sized plan 600 lines, section by country (typically 50
lines per country), and with many milestones, some of which are key.
I want to draw a line to show for each section the date that the
section needs to finish, ( something similar to the status line ) but
in a single plan it will be different for each section. i have used
the date10 field and identified the date by which key activities
should be completed by, but i cant draw a vertical bar, any
suggestions ??

pipmonck,
In this case I think your best bet is to use the drawing tool to
manually draw vertical lines where desired. Actually this approach has a
couple of advantages. First, you can "tie" the vertical line to the
desired milestone (i.e. it will move as the milestone moves). Second,
you can draw the line only as long as necessary in each section. That
way, the whole plan won't have a bunch of vertical lines running through
it.

Hope this helps.
John
Project MVP

 

[pipmonck]

pipmonck,
In this case I think your best bet is to use the drawing tool to
manually draw vertical lines where desired. Actually this approach has a
couple of advantages. First, you can "tie" the vertical line to the
desired milestone (i.e. it will move as the milestone moves). Second,
you can draw the line only as long as necessary in each section. That
way, the whole plan won't have a bunch of vertical lines running through
it.

Hope this helps.
John
Project MVP

Ok Thanks John,

Phil

 

[pipmonck]

pipmonck,
In this case I think your best bet is to use the drawing tool to
manually draw vertical lines where desired. Actually this approach has a
couple of advantages. First, you can "tie" the vertical line to the
desired milestone (i.e. it will move as the milestone moves). Second,
you can draw the line only as long as necessary in each section. That
way, the whole plan won't have a bunch of vertical lines running through
it.

Hope this helps.
John
Project MVP

This works but.... when i look at the VBA code to copy and repeat the
code so that i can add & remove the drawing for each milestone , the
code only shows as below,

Sub Macro1()
' Macro Macro1
' Macro Recorded 24/06/08 by Phil Monckton.
DrawingCreate Type:=pjLine
DrawingProperties
DrawingProperties
DrawingProperties
end Sub

how do i get to specify the Drawing properties for each line, they
will be different sizes etc, possibly different colours as well...

any suggestions will be very greatly appreciated...

Phil

 

[John]

This works but.... when i look at the VBA code to copy and repeat the
code so that i can add & remove the drawing for each milestone , the
code only shows as below,

Sub Macro1()
' Macro Macro1
' Macro Recorded 24/06/08 by Phil Monckton.
DrawingCreate Type:=pjLine
DrawingProperties
DrawingProperties
DrawingProperties
end Sub

how do i get to specify the Drawing properties for each line, they
will be different sizes etc, possibly different colours as well...

any suggestions will be very greatly appreciated...

Phil

Phil,
Even though you posted in the developer's newsgroup, it didn't appear
you were trying to add the milestone marker lines via VBA. As it turns
out, Project's object model does not expose drawing tool properties.
And, as a matter of fact, the drawing methods that are available via VBA
are all but useless since executing code for them requires extensive
user interaction.

The bottom line is, manually set up your milestone vertical lines,
(location and format), and forget about trying to create them using VBA.
Not the answer you wanted, but sometimes the "dragon" wins.

Just a hint. If you want the line to lie on top of a milestone diamond,
set the horizontal offset to be 0.04 in.

John
Project MVP

 

[John]

Ok Thanks John,

Phil

Phil,
You're welcome and thanks for the feedback.

John