Handling Missing Data

If the Value property for a data point is set to a special value known as the hole value, the chart treats the data point as a missing value, and does not display it on the chart. This hole value is specified by the HoleValue property of the Chart3DData object.

For example, the following code treats the point in the third row and first column as a missing value:

With Chart3D1.ChartGroups(1).ElevationData

       .HoleValue = 999.1

       .Value(3, 1) = 999.1

End With