OWC (Office Web Components) Interpolation

[gbaughma]

I have some data that I'm plotting with OWC, however I can't find if there's a way to have it interpolate missing data. I know that in Excel you can do this; you can tell Excel to either leave blanks in a line chart, set it to 0's, or interpolate.

I need to do the same thing with OWC, because due to a nice "feature" in OWC, if you are plotting two series, and one of them is missing data, it will first plot the X axis that has both pieces of data, then "tack" the rest of the data on to the end, messing up the dateline across the X axis.

Anyway... now I've rambled... but is there a way in OWC to turn on Interpolation, like there is in Excel charting?



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com

 

[gbaughma]

Addendum:

I'm looking for the OWC equiv. of Excel's

ActiveChart.DisplayBlanksAs = xlInterpolated



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com

 

[xlhelp]

Please look here

I don't particularly care about apathy

 

[gbaughma]

Yes... I found that link earlier... but that's using Excel. I'm doing this project in VBScript with OWC to display on a web page.

Thank you for the link though.



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com