Problem in displaying dates on y-axis in owc chart 9.0

V

Vijay

I am displaying x and y axis data in the owc chart9.0
using a recordset.On x-axis i am displaying project names
and on y-axis i am displaying planned completion date and
actual completion date of project. All these i am getting
from datbase using a recordset.My Problem is if any of the
record in the db contains null or does not contain any
value, then the dates on the y-axis are showing a range
from 1899, 1900, 1913, 1927 etc even if the data is
pertaining to current and previous years and the graph is
completely screwed up. Can any help me out for this.

Thanks in Advance
Regds
Vijay
 
T

Thao Moua [ms]

If I remembered correctly, in OWC9 when binding to a
datasource as in a recordset, we expect the data to be
complete otherwise Chart tries to either group or convert
the date data. In OWC10 we improved databinding and
respect empty values and leave date value as they are.

-tm
 
V

Vijay

Hi,
Thanks for the reply, but i found out a solution for that.
The following code allows us to specify the range so that
the graph will not get disturbed:

oChartSpace.Charts(0).SeriesCollection(0).Scalings
(2).HasAutoMaximum = false
oChartSpace.Charts(0).SeriesCollection(0).Scalings
(2).HasAutoMinimum = false
oChartSpace.Charts(0).SeriesCollection(0).Scalings
(2).Maximum=38000
oChartSpace.Charts(0).SeriesCollection(0).Scalings
(2).Minimum=37000

the no's (38000 and 37000) which are assigned are the
no.of days passed since 1900. This will solve the problem.

Regds
Vijay
 
Top