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