UpBars object (Word)
Represents the up bars in a chart group.
Up bars connect points on series one with higher values on the last series in the chart group (the lines go up from series one). Only 2D line groups that contain at least two series can have up bars. This object is not a collection. There is no object that represents a single up bar; you either enable up bars for all points in a chart group or you disable them.
If the HasUpDownBars property is False, most properties of the UpBars object are disabled.
Use the UpBars property to return the UpBars object. The following example enables up and down bars for chart group one of the first chart in the active document. The example then sets the up bar color to blue and sets the down bar color to red.
With ActiveDocument.InlineShapes(1) If .HasChart Then With .Chart.ChartGroups(1) .HasUpDownBars = True .UpBars.Interior.Color = RGB(0, 0, 255) .DownBars.Interior.Color = RGB(255, 0, 0) End With End If End With
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.