By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,097 Members | 1,170 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,097 IT Pros & Developers. It's quick & easy.

MSChart handling missing data

P: 1
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.Length - 1
If (graphArray(i, 0) = 0.0) Then
graphArray(i, 0) = 0.0

End If
Next

'Set the default Chart Type to 2D Bar Type
AxMSChart2.chartType = MSChart20Lib.VtChChartType.VtChChartType2dLine
AxMSChart2.ShowLegend = False
AxMSChart2.ChartData = graphArray
Mar 31 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.