How to (not) display blanks in a chart

[Florent]

Hi,

I am using OWC11.

I am trying to make a chart with dates as a category.

The problem is that I dont have a value for every date, for example, here is
my tab:
02/12/2006 79
02/13/2006 85
02/15/2006 89
02/16/2006 83

And with the table above, on my chart, even if there is no entry for the
14th of february in my data collection, it will create an entry and set a
value of 0, causing my chart to be false (if it adds a value for the 14th of
february, I would like it to be average).

I dont have that issue using the Excel API, I only have it with OWC.

Even if I had that issue with the Excel API, on the chart object there is a
"DisplayBlanksAs" property (which by default displays blanks with an average
value) that could help me fix that, but I couldnt find any similar thing in
the ChChart object of OWC.

Does anybody have a clue on how to not display any markpoint for dates that
aren't in the datacollection, or to eventually to display average value?

Thanks!

 

[Alvin Bruney - ASP.NET MVP]

Here is one possible fix:
http://support.microsoft.com/default.aspx?scid=kb;en-us;326103

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/