Table of contents
TOC
Collapse the table of content
Expand the table of content

Application.ResourceGraphBarStylesEx Method (Project)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Sets the styles of bars on the Resource Graph view, where colors can be hexadecimal values.

Syntax

expression. ResourceGraphBarStylesEx( ** TopLeftShowAs, ** TopLeftColor, ** TopLeftPattern, ** BottomLeftShowAs, ** BottomLeftColor, ** BottomLeftPattern, ** TopRightShowAs, ** TopRightColor, ** TopRightPattern, ** BottomRightShowAs, ** BottomRightColor, ** BottomRightPattern, ** ShowValues, ** ShowAvailabilityLine, ** PercentBarOverlap, ** ProposedLeftShowAs, ** ProposedLeftColor, ** ProposedLeftPattern, ** ProposedRightShowAs, ** ProposedRightColor, ** ProposedRightPattern** )

expression An expression that returns an Application object.

Parameters

NameRequired/OptionalData TypeDescription
TopLeftShowAsOptionalIntegerThe bar type for the overallocated resources category in the upper-left corner of the Bar Styles dialog box. Can be one of the following PjResourceGraphStyle constants: pjBar, pjArea, pjStep, pjLine, pjStepLine, or pjDoNotShow.
TopLeftColorOptionalIntegerThe bar color for the overallocated resources category in the upper-left corner of the Bar Styles dialog box. Can be a hexadecimal value, where red is the last byte. For example, the value &;HFF0000 is blue and &;H00FFFF is yellow.
TopLeftPatternOptionalIntegerThe bar pattern for the overallocated resources category in the upper-left corner of the Bar Styles dialog box. Can be one of the PjResourceGraphPattern constants.
BottomLeftShowAsOptionalIntegerThe bar type for the allocated resources category (the middle left section) of the Bar Styles dialog box. Can be one of the PjResourceGraphStyle constants.
BottomLeftColorOptionalIntegerThe bar color for the allocated resources category (the middle left section) of the Bar Styles dialog box. Can be a hexadecimal value, where red is the last byte. For example, the value &;HFF00 is green.
BottomLeftPatternOptionalIntegerThe bar pattern for the allocated resources category (the middle left section) of the Bar Styles dialog box. Can be one of the PjResourceGraphPattern constants.
TopRightShowAsOptionalIntegerThe bar type for the overallocated resources category in the upper-right corner of the Bar Styles dialog box. Can be one of the PjResourceGraphStyle constants.
TopRightColorOptionalIntegerThe bar color for the overallocated resources category in the upper-right corner of the Bar Styles dialog box. Can be a hexadecimal value, where red is the last byte.
TopRightPatternOptionalIntegerThe bar pattern for the overallocated resources category in the upper-right corner of the Bar Styles dialog box. Can be one of the PjResourceGraphPattern constants.
BottomRightShowAsOptionalIntegerThe bar type for the allocated resources category (the middle right section) of the Bar Styles dialog box. Can be one of the PjResourceGraphStyle constants.
BottomRightColorOptionalIntegerThe bar color for the allocated resources category (the middle right section) of the Bar Styles dialog box. Can be a hexadecimal value, where red is the last byte.
BottomRightPatternOptionalIntegerThe bar pattern for the allocated resources category (the middle right section) of the Bar Styles dialog box. Can be one of the PjResourceGraphPattern constants.
ShowValuesOptionalBooleanTrue if the corresponding values appear below the bars.
ShowAvailabilityLineOptionalBooleanTrue if a horizontal line appears where a resource reaches its maximum availability.
PercentBarOverlapOptionalIntegerA number from 0 to 100 that specifies the overlap percentage of displayed bars.
ProposedLeftShowAsOptionalIntegerThe bar type for the proposed bookings category in the bottom left section of the Bar Styles dialog box. Can be one of the PjResourceGraphStyle constants.
ProposedLeftColorOptionalIntegerThe bar color for the proposed bookings category in the bottom left section of the Bar Styles dialog box. Can be a hexadecimal value, where red is the last byte.
ProposedLeftPatternOptionalIntegerThe bar pattern for the proposed bookings category in the bottom left section of the Bar Styles dialog box. Can be one of the PjResourceGraphPattern constants.
ProposedRightShowAsOptionalIntegerThe bar type for the proposed bookings category in the bottom right section of the Bar Styles dialog box. Can be one of the PjResourceGraphStyle constants.
ProposedRightColorOptionalIntegerThe bar color for the proposed bookings category in the bottom right section of the Bar Styles dialog box. Can be a hexadecimal value, where red is the last byte.
ProposedRightPatternOptionalIntegerThe bar pattern for the proposed bookings category in the bottom right section of the Bar Styles dialog box. Can be one of the PjResourceGraphPattern constants.

Return Value

Boolean

Remarks

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

Note If you use any of the PjColor enumeration constants for the color parameters, the color will be nearly black. For example, the value of pjGreen is 9, which in the ResourceGraphBarStylesEx method is a very dark red. To use only the sixteen colors available with PjColor constants, use the ResourceGraphBarStyles method.

Example

The following line of code sets proposed resources in the Resource Graph view as a step line in a light blue-green color.

Application.ResourceGraphBarStylesEx ProposedRightShowAs:=pjStepLine, ProposedRightColor:=&;HD0FF00 
© 2018 Microsoft