SetSize Method

       

Resizes the number of data columns and rows, as well as the number of levels of column labels and row labels of a data grid associated with a chart at one time.

Syntax

object.SetSize (rowLabelCount, columnLabelCount, dataRowCount, columnLabelCount)

The SetSize method syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
rowLabelCount Integer. Returns or sets the number of levels of row labels you want on the data grid.
columnLabelCount Integer. Returns or sets the number of levels of column labels you want on the data grid.
dataRowCount Integer. Returns or sets the number of data rows you want on the data grid.
columnLabelCount Integer. Returns or sets the number of data columns you want on the data grid.

Remarks

This method can be used in place of RowCount, ColumnCount, RowLabelCount and ColumnLabelCount.

If you reduce the size of the data grid, data in deleted rows or columns is destroyed.