How do I get gaps in a chart with values from an array using VBA?

Hi

I am trying to make a plot using VBA.
I am storing the values I want to plot in arrays, but I also want to have some gaps in the plot.
I found this really helpfull site: http://peltiertech.com/WordPress/vba...-excel-charts/.
But since I am storing the values in arrays, another problem occurs.
I want to insert "" where the gaps should be, and want to have numeric values elsewhere.

How should I declare the arrays?

If I use
"Dim Array As Variant"
all the points in the plot becomes zero.

If I use
"Dim Array As Double" or
"Dim Array As Long" I get an "Type Mismatch" when I try to insert the empty ""s.

Hm, then I got a Type mismatch when I wrote
"ActiveChart.SeriesCollection(1).Values = arr"

But i kind of solved it. I just made another array "Gaps" that stored the indices where the gaps should be. and then checked if the points were in Gaps when I edited the markerstyle.

I dont want any lines around the gaps. If I add 0's, there will be lines from the points around the gaps and down to the xaxis which I dont want. It is more or less the same problem as explained in this site: http://peltiertech.com/WordPress/vba...-excel-charts/.

hi annabroyn, it would help if you can you post your file with the coding