FirstLabelRow Property
The FirstLabelRow property returns or sets the first row of data to be used for plot or axis labels. Returns a Long.
Syntax
object.FirstLabelRow
object.FirstLabelRow = FirstLabelRow
Parameter | Type | Description |
FirstLabelRow | Long | required, row number |
Remarks
Set the AutoFirstLabelRow Property to false before setting the FirstLabelRow.
Example 1
This example shows how to return the First row value.
'Return "First row value"
Debug.Print "First label row = "; PlotLabels.FirstLabelRow
Example 2
This example shows how to set the First row value.
'Set "First row" to "Custom"
PlotLabels.AutoFirstLabelRow = False
'Set "First row value" to 5
PlotLabels.FirstLabelRow = 5
Example 3
This example shows how to set the First row to 10 for an axis.
'Set "First row" to Custom and the value to 10
XAxis1.TickLabels.AutoFirstLabelRow = False
XAxis1.TickLabels.FirstLabelRow = 10
Used by: AutoHLPlot object, AutoPlotLabels object, AutoAxisTickLabels object