WorksheetLabelCol Property

The WorksheetLabelCol property returns or sets the Label column for tick mark labels when Worksheet is the Label source. Returns a Long.

Syntax

object.WorksheetLabelCol

object.WorksheetLabelCol = WorksheetLabelCol

 

Parameter Type Description
WorksheetLabelCol Long required, default = 2 (column B)

 

Remarks

Set the Mode property to grfLabelsWorksheet before using this command. Set the data column with the WorksheetDataCol property.

Example

This example shows how to specify the label column for tick mark labels from the worksheet.

TickLabels.WorksheetLabelCol = 1

 

Used by: AutoAxisTickLabels object