Office Web Components Blank Cell (OWC11)

Fillx

New member
Joined
May 19, 2009
Messages
1
Programming Experience
1-3
Hi I was wondering if someone could help me with this problem I have plotting with Office Web Components...

In have a data sheet with x vs y data where if a value is zero it is removed and replaced with blank ("") which is required for what I am designing.

The reason I do this is that in excel if the blank is encountered the two points either side of the blank cell are not joined by a line even in the same series when it is plotted. However with OWC11 the points either side are joined and I need to prevent this from happening but still want to use a line plot.

Any help would be much appreciated - how do I stop these points from being joined with a line without having to add another series?!
 
Top Bottom