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