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