I've got the following code which produces a line chart using MSChart. Is there anyway of doing interpolation (ie handle missing data) so that if an array element has a value of 0 it won't be plotted. I've read about the NA function in excel but how do you apply this to visual basic code?


Dim graphArray(100, 0) As Double
' Code inserted here which assigns values to the graphArray

For i = 0 To graphArray.Leng th...