J
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
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