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

See Also

Plot Labels

Hi-Low-Close Plot Labels

Ternary Plot Labels