Handling Missing Data

If the Y property for a data point is set to a special value known as the hole value, 2D 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 Chart2DData object.

For example, the following code treats the third point in the first data series as a missing value:

With Chart2D1.ChartGroups(1).Data
       .HoleValue = 999.1
       .Y(1, 3) = 999.1
End With