Page 1 of 1

Line Chart - multiple series ploting data from dataset one series incorrect

Posted: Fri Jan 26, 2007 1:18 am
by jing
I have created a line chart, where x-axis values are Dates (Date Time Sent) and y-axis values are Disk usages. These data were obtained from a datasource.
Datasource "DiskUsages" looks something like
Drive | DiskUsage | DateTimeSent
C:| 39.3| 22/7/2006
D:| 4.6| 22/7/2006
E:| 3| 22/7/2006
C:| 39.9| 24/7/2006
D:| 4.6| 24/7/2006
C:| 40| 2/8/2006
D:| 6| 2/8/2006
E:| 5| 2/8/2006

On my line chart, I have 3 series, one for each of the Drive letters. Series for drive C and D are fine.
My problem is with the series for drive E.
As you can see from the datasource table above, drive E does not have data for 24/7/2006.
So on the line chart, there should only be 2 data points, one at 22/7/2006 and one at 2/8/2006. Instead, I have 2 data points, one at 22/7/2006 which is fine, but one at 24/7/2006. The diskusage is correct at 5GB, but not ploted on the right date!!!

How can I fix this problem? I have looked at the properties of the chart and on the forum, I haven't manage to find any thing...

any help will be GREAT

thank you very much

Line Chart - multiple series ploting data from dataset one series incorrect

Posted: Fri Jan 26, 2007 7:14 am
by Edward
An AutoSeriesKeyDataColumn property has one restriction on use. The count of the values for axes must be the same for all series.
May exists a situation when a count of points differs for the collection of the autoseries. But all series will be output in correct way only when on the X Axis will not exists a "holes" (not filled values).
So if you are using autoseries, please provide the same count of values for each autoseries.

So if you will define an additional row

E:| 3 | 24/7/2006

then your "E" series will be shown in the correct way.

Thank you.