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