WksLblCol Property

The WksLblCol property returns or sets the worksheet column for ternary diagram worksheet labels when the UseWksLbls property is true. Returns a Long.

Syntax

object.WksLblCol

object.WksLblCol = WksLblCol

 

Parameter Type Description
WksLblCol Long required, default =1 (column A)

 

Example 1

This example shows how to return the default label column.

Debug.Print "WksLblCol = "; TernaryPlot.WksLblCol

Example 2

This example shows how to set the label column to column C.

TernaryPlot.WksLblCol = 3

 

Used by: AutoTernaryPlot object