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

See Also

Plot Labels

Hi-Low-Close Plot Labels

Ternary Plot Labels