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

See Also

Plot Labels

Hi-Low-Close Plot Labels

Ternary Plot Labels