DataCol Property
The DataCol property returns or sets the worksheet column containing data to be plotted. Returns a Long.
Syntax
object.DataCol
object.DataCol = DataCol
Parameter | Type | Description |
DataCol | Long | required, column (column A equals 1) |
Example
This example shows how to use column B for a pie chart.
PieChart1.dataCol = 2
Used by: AutoHistogram object, AutoPieChart object, AutoRoseDiagram object