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