Adding Rows and Columns

To add rows to a chart group, do the following:

· Set the RowCount property to the new number of rows.

· If the data is irregularly-gridded, set the RowDelta property for the space between a new row and its predecessor.

· Set the Value property for each of the new points.

For example, the following code adds a fourth row of three points to a chart group:

With Chart3D1.ChartGroups(1).ElevationData

.RowCount = 4

' set space between third row and fourth row

' (not necessary if data is regularly-gridded)

.RowDelta(3) = 1.0

.Value(4, 1) = 5.17

.Value(4, 2) = 5.84

.Value(4, 3) = 6.33

End With

New columns can be added in much the same way:

· Set the ColumnCount property to the new number of columns.

· If the data is irregularly-gridded, set the ColumnDelta property for the space between a new column and its predecessor.

· Set the Value property for each of the new points.