Type | Description | |||
Type as OverlaidBarsTypeEnum | Specifies the Type of the overlaid being changed | |||
Variant | A Variant expression that specifies the option for the current overlaid type. |
Overlaid(exOverlaidBarsIntersect) ( string expression ) specifies the name of the bar to be displayed on the portion that laid over bars. By default, the Overlaid(exOverlaidBarsIntersect) property is empty, so nothing is displayed if the Overlaid is exOverlaidBarsIntersect. You MUST specify the name of the task to display the portion that covers the bars if the Overlaid is exOverlaidBarsIntersect. For instance, the following sample creates a copy of the task bar with a different color ( red ) and display it when two or more tasks covers.
With .Chart.Bars.Copy("Task", "RTask") .Color = RGB(255, 0, 0) End With With .Chart.Bars("Task") .OverlaidType = exOverlaidBarsIntersect .Overlaid(exOverlaidBarsIntersect) = "RTask" End With
Overlaid(exOverlaidBarsTransparent) ( long expression ) specifies the percent of transparency to be applied to bars that covers other bars. By default, the Overlaid(exOverlaidBarsTransparent) property is 50% ( semi-transparent ).