AutoLastLabelRow Property
The AutoLastLabelRow property returns or sets if the last row containing data should be automatically used for the plot or axis labels. Returns a Boolean.
Syntax
object.AutoLastLabelRow
object.AutoLastLabelRow = AutoLastLabelRow
Parameter | Type | Description |
AutoLastLabelRow | Boolean | required, default is true (automatically use the last row containing data) |
Example 1
This example shows how to return if the last row containing data is automatically used.
'Return if "Last row" is set to Auto
Debug.Print "AutoLastLabelRow = "; PlotLabels.AutoLastLabelRow
Example 2
This example shows how to set the Last row to Custom.
'Set "Last row" to Custom
PlotLabels.AutoLastLabelRow = False
Example 3
This example shows how to set the Last row to 20for an axis.
'Set "First row" to Custom and the value to 10
XAxis1.TickLabels.AutoLastLabelRow = False
XAxis1.TickLabels.LastLabelRow = 20
Used by: AutoHLPlot object, AutoPlotLabels object, AutoAxisTickLabels object