Office Web Components Blank Cell (OWC11)


New member
May 19, 2009
Programming Experience
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