Application.ResourceGraphBarStyles method (Project)
Sets the styles of bars on the Resource Graph view.
Syntax
expression. ResourceGraphBarStyles( _TopLeftShowAs_, _TopLeftColor_, _TopLeftPattern_, _BottomLeftShowAs_, _BottomLeftColor_, _BottomLeftPattern_, _TopRightShowAs_, _TopRightColor_, _TopRightPattern_, _BottomRightShowAs_, _BottomRightColor_, _BottomRightPattern_, _ShowValues_, _ShowAvailabilityLine_, _PercentBarOverlap_, _ProposedLeftShowAs_, _ProposedLeftColor_, _ProposedLeftPattern_, _ProposedRightShowAs_, _ProposedRightColor_, _ProposedRightPattern_ )
expression A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| TopLeftShowAs | Optional | Integer | The 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. |
| TopLeftColor | Optional | Integer | The bar color for the overallocated resources category in the upper-left corner of the Bar Styles dialog box. Can be one of the PjColor constants. |
| TopLeftPattern | Optional | Integer | The 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. |
| BottomLeftShowAs | Optional | Integer | The bar type for the allocated resources category (the middle left section) of the Bar Styles dialog box. Can be one of the PjResourceGraphStyle constants. |
| BottomLeftColor | Optional | Integer | The bar color for the allocated resources category (the middle left section) of the Bar Styles dialog box. Can be one of the PjColor constants. |
| BottomLeftPattern | Optional | Integer | The bar pattern for the allocated resources category (the middle left section) of the Bar Styles dialog box. Can be one of the PjResourceGraphPattern constants. |
| TopRightShowAs | Optional | Integer | The 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. |
| TopRightColor | Optional | Integer | The bar color for the overallocated resources category in the upper-right corner of the Bar Styles dialog box. Can be one of the PjColor constants. |
| TopRightPattern | Optional | Integer | The 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. |
| BottomRightShowAs | Optional | Integer | The bar type for the allocated resources category (the middle right section) of the Bar Styles dialog box. Can be one of the PjResourceGraphStyle constants. |
| BottomRightColor | Optional | Integer | The bar color for the allocated resources category (the middle right section) of the Bar Styles dialog box. Can be one of the PjColor constants. |
| BottomRightPattern | Optional | Integer | The bar pattern for the allocated resources category (the middle right section) of the Bar Styles dialog box. Can be one of the PjResourceGraphPattern constants. |
| ShowValues | Optional | Boolean | True if the corresponding values appear below the bars. |
| ShowAvailabilityLine | Optional | Boolean | True if a horizontal line appears where a resource reaches its maximum availability. |
| PercentBarOverlap | Optional | Integer | A number from 0 to 100 that specifies the overlap percentage of displayed bars. |
| ProposedLeftShowAs | Optional | Integer | The 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. |
| ProposedLeftColor | Optional | Integer | The bar color for the proposed bookings category in the bottom left section of the Bar Styles dialog box. Can be one of the PjColor constants. |
| ProposedLeftPattern | Optional | Integer | The 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. |
| ProposedRightShowAs | Optional | Integer | The 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. |
| ProposedRightColor | Optional | Integer | The bar color for the proposed bookings category in the bottom right section of the Bar Styles dialog box. Can be one of the PjColor constants. |
| ProposedRightPattern | Optional | Integer | The 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 ResourceGraphBarStyles method without specifying any arguments displays the Bar Styles dialog box.
To edit the resource graph styles where the colors can be specified as hexadecimal RGB values, use the ResourceGraphBarStylesEx method
Example
The following line of code sets proposed resources in the Resource Graph view as a step line in a blue-green color.
Application.ResourceGraphBarStylesEx ProposedRightShowAs:=pjStepLine, ProposedRightColor:=pjTeal
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.