Set series Z values (bubble sizes) from data stored in a single-dimension array (for Bubble charts).

object.SetSeriesZValuesFromArray index, values

Arguments

object: Required. A Chart object.
index: Required. An integer value that specifies the zero-based index of the series in the chart object.
values: Required. A single-dimension array containing the series Z values (or bubble sizes) as elements.

Remarks

Note: This method is available when manipulating Bubble data series required for displaying Bubble charts. Note that the Chart type (bubble, bar, column, line, etc) is defined in the Swiff Chart style file (.scs) which must be loaded via the LoadStyle method.

The data stored in the array must be numerical values.

If the index argument refers to a series that does not exist in the chart object, the series is created.

index must be superior or equal to 0.

VBScript Sample Code

The following VBScript code shows how to store the XY and Sizes values of the table below using the SetSeriesZValuesFromArray method. This table has one series named "Production". This series contains independant XY and Sizes values.

Production
X	Y	Bubble Size (Z)
4.5	12	456
1.2	7.5	478
2.5	11.3	314
2.9	9.2	125
1.8	5.3	265

Dim array_x(4)
Dim array_y(4)
Dim array_z(4)

array_x(0)= 1
array_x(1)= 2
array_x(2)= 3
array_x(3)= 4
array_x(4)= 5

array_y(0)= 12
array_y(1)= 7.5
array_y(2)= 11.3
array_y(3)= 9.2
array_y(4)= 5.3

array_z(0)= 456
array_z(1)= 478
array_z(2)= 314
array_z(3)= 125
array_z(4)= 265

'Add the first series "Production"
chart.SetSeriesCaption 0, "Production"

'Fill the first series with XY values stored in the array variables
chart.SetSeriesXValuesFromArray 0, array_x
chart.SetSeriesYValuesFromArray 0, array_y

// Fill the first series with Bubble Size values stored in the array_z variable
chart.SetSeriesZValuesFromArray 0, array_z

Arguments

Remarks

VBScript Sample Code

See Also