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