ZCol Property

The ZCol property returns or sets the Z data column for a plot. Returns a Long.

Syntax

object.ZCol

object.ZCol = ZCol

 

Parameter Type Description
ZCol Long required, column A equals 1

Remarks

Assign -1 to ZCol when plotting the data according to the Row number. Assign 0 to ZCol when plotting the data according to the Sequence number (i.e. total number of rows used).

Example 1

This example shows how to set the Z column for a bubble plot.

Bub1.zCol = 2

Example 2

This example shows how to return the Z column for a bubble plot.

Debug.Print Bub1.zCol

 

Used by: Auto3DXYZBarChart object, AutoBubblePlot object, AutoTernaryPlot object, AutoXYZPlot object, Auto3DXYZVectorPlot object