AutoFirstLabelRow Property
The AutoFirstLabelRow property returns or sets if the first row containing data should be automatically used for the plot or axis labels. Returns a Boolean.
Syntax
object.AutoFirstLabelRow
object.AutoFirstLabelRow = AutoFirstLabelRow
| Parameter | Type | Description |
| AutoFirstLabelRow | Boolean | required, default is true (automatically use the first row containing data) |
Example 1
This example shows how to return if the first row containing data is automatically used.
'Return if "First row" is set to Auto
Debug.Print "AutoFirstLabelRow = "; PlotLabels.AutoFirstLabelRow
Example 2
This example shows how to set the First row to Custom.
'Set "First row" to Custom
PlotLabels.AutoFirstLabelRow = False
Example 3
This example shows how to set the First row to 10for 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