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