Customizing Chart Elements > ChartLabels Programming Considerations > Defining the ChartLabel |
The ChartLabel object provides a number of properties that help you define and position the chart label. The most important of these properties are the following:
· The Text property specifies the text to appear in the chart label, and is of type Label.
· The Plane property specifies the orientation of the chart label. The orientation is specified as a plane constant.
· The IsConnected property is a Boolean which specifies whether a line is to be drawn from the chart label to its attached location. If True, the line is drawn.
The following code sets the above properties:
With Chart3D1.ChartLabels(1)
.Text = "Here is my chart label"
.Plane = oc3dXZPlane
.IsConnected = True
End With