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