Empty values to OWC graph

[J Kruger]

Hello,

I create graphs from asp with OWC version 11. I read data from the
database and generate the graphs based on this.

If a db column has a null or 0 value, the category on the graph must
display an empty value next to it.
What happens is that the graph ignores it and drops group all the
non-null values together which cause the empty value to display next to
the 1st or last category.
The only way I can fix this is if I put a 0 in, but I do not want to do
that.

When I do the same in Excel Xp, it displays correctly.

set objCSpace = Server.CreateObject("OWC11.Chartspace")
....
categories = Array("A","B","C","D")
values = Array(1,2,,4)
....
objChart.SeriesCollection(0).SetData 1, -1, categories
objChart.SeriesCollection(series).SetData 2, -1, values
....
DISPLAYS: A=1,B=2,C=4,D=

Regards,
J Kruger

 

[Alvin Bruney - ASP.NET MVP]

There is an article on msdn indicating how to deal with null data points in
the owc chart. have a look for it. It's also in the black book.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[Prasad Yarlagadda]

Check out article #326103 in MSDN. See if that helps you.