GanttBarFormat Method

Formats Gantt bars.

Syntax

expression**.GanttBarFormat(TaskID, GanttStyle, StartShape, StartType, StartColor, MiddleShape, MiddlePattern, MiddleColor, EndShape, EndType, EndColor, LeftText, RightText, TopText, BottomText, InsideText, Reset, ProjectName)**

*expression   *     Optional. An expression that returns an Application object.

TaskID    Optional Long. The identification number of the task represented by the Gantt bar to be changed. The default is to change the Gantt bars of the selected tasks.

GanttStyle    Optional Integer. The style applied to the Gantt bar to be formatted. The value for GanttStyle is based on the position of the bar style in the list. For example, the value 3 returns the third bar style in the list.

PjBarEndShape

Constant
pjNoBarEndShape
pjHouseUp
pjHouseDown
pjDiamond
pjCircleDiamond
pjTriangleUp
pjTriangleDown
pjTriangleRight
pjTriangleLeft
pjCircleTriangleUp
pjCircleTriangleDown
pjArrowUp
pjArrowDown
pjCircleArrowUp
pjCircleArrowDown
pjCaretDownTop
pjCaretUpBottom
pjLineShape
pjSquare
pjCircle
pjStar

StartType    Optional Long. The start type of the Gantt bar. Can be one of the following PjBarType constants: pjDashed, pjFramed, or pjSolid.

PjColor

pjColorAutomatic pjNavy
pjAqua pjOlive
pjBlack pjPurple
pjBlue pjRed
pjFuchsia pjSilver
pjGray pjTeal
pjGreen pjYellow
pjLime pjWhite
pjMaroon  

MiddleShape    Optional Long. The middle shape of the Gantt bar. Can be one of the following PjBarShape constants: pjNone, pjRectangleBar, pjRectangleTop, pjRectangleMiddle, pjRectangleBottom, pjLineTop, pjLineMiddle, or pjLineBottom.

PjFillPattern

pjDarkFillPattern pjLineCrossPattern
pjDiagonalCrossPattern pjLineHorizontalPattern
pjDiagonalLeftPattern pjLineVerticalPattern
pjDiagonalRightPattern pjMediumFillPattern
pjHollowPattern pjSolidFillPattern
pjLightFillPattern  

MiddleColor    Optional Long. The middle color of the Gantt bar. Can be one of the PjColor constants.

EndShape    Optional Long. The end shape of the Gantt bar. Can be one of the PjBarEndShape constants.

EndType    Optional Long. The end type of the Gantt bar. Can be one of the following PjBarType constants: pjDashed, pjFramed, or pjSolid.

EndColor    Optional Long. The end color of the Gantt bar. Can be one of the PjColor constants.

LeftText    Optional String. The task field to display to the left of the Gantt bar.

RightText    Optional String. The task field to display to the right of the Gantt bar.

TopText    Optional String. The task field to display above the Gantt bar.

BottomText    Optional String. The task field to display below the Gantt bar.

InsideText    Optional String. The task field to display inside the Gantt bar.

Reset    Optional Boolean. True if the bar formatting is reset to the default formatting of the style in the Bar Styles dialog box.

ProjectName    Optional String. The name of the project containing TaskID if consolidation is involved. The default value is the name of the active project.

Remarks

Using the GanttBarFormat method without specifying any arguments displays the Bar Styles dialog box.

Use the GanttBarFormat method to change the formatting of Gantt bars from their default styles. To define the default styles, use the GanttBarStyleEdit method.

Applies to | Application Object

See Also | GanttBarLinks Method | GanttBarSize Method | GanttBarStyleEdit Method | GanttBarTextDateFormat Method | GanttChartWizard Method | GanttShowBarSplits Method | GanttShowDrawings Method