Hi!
Why don't you just skip the values, instead of making them Hidden?
I.e. change this:
chartObj.XValue[2,0] = 2/20/1998chartObj.Value[2,0] = 6.22chartObj.XValue[2,1] = 6/7/2000chartObj.Value[2,1] = Chart.HiddenchartObj.XValue[2,2] = 10/12/2001chartObj.Value[2,2] = 7.81chartObj.XValue[2,3] = 5/6/2003chartObj.Value[2,3] = Chart.HiddenchartObj.XValue[2,4] = 5/7/2003chartObj.Value[2,4] = 7.14chartObj.XValue[2,5] = 9/30/2007chartObj.Value[2,5] = 7.86
to this:
chartObj.XValue[2,0] = 2/20/1998chartObj.Value[2,0] = 6.22chartObj.XValue[2,1] = 10/12/2001chartObj.Value[2,1] = 7.81chartObj.XValue[2,2] = 5/7/2003chartObj.Value[2,2] = 7.14chartObj.XValue[2,3] = 9/30/2007chartObj.Value[2,3] = 7.86
If you are not using category x-axis, then it should just connect your (x,y)-pairs, without caring about hidden points (if this is what you inteded - I am not sure).
If you have an option to use Bar gallery, you may try it also, it renders hidden points differently.
Veki