YCol Property
The YCol property returns or sets the Y data column for a plot. Returns a Long.
Syntax
object.YCol
object.YCol = YCol
Parameter | Type | Description |
YCol | Long | required, column A equals 1 |
Remarks
In polar plots this column is used for radius values.
Assign -1 to YCol when plotting the data according to the Row number. Assign 0 to YCol 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 Y column for a bar chart.
Bar1.yCol = 1
Example 2
This example shows how to return the Y column for a bar chart.
Debug.Print Bar1.yCol
Used by: Auto3DXYZBarChart object, AutoBarChart object, AutoBubblePlot object, AutoLinePlot object, AutoTernaryPlot object, Auto3DXYZVectorPlot object