Working with Data > Grid and Irregular Grid Data > 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.