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?!
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?!