Columns Method [AutoRadarGraph]
The Columns method sets the columns on which the axes are based. Accepts an array.
Syntax
object.Columns(Columns)
Parameter | Type | Description |
Columns | Variant | required |
Remarks
-
The number of elements in the array determines the number of the axes, starting at 0
-
Values in the array are the index numbers of columns in the data sheet, starting at 1.
-
All previous graph axes are deleted
Example
This example demonstrates how to assign columns A through D to a set of axes in the radar graph.
'Declares a long array
Dim Array1(10) As Long
Array1(0) = 1
Array1(1) = 2
Array1(2) = 3
Array1(3) = 4
'Call Columns
Graph1.Columns(Array1)
Used by: AutoRadarGraph object