Line Chart w/ two Series Not Overlaying

[User (Legacy)]

I have a RS with three columns - Year, Week, and Value.  I am using the

following code with some success, but the two line charts are side by side

instead of on top of each other.

Here is my code, and I have attached a bmp of the problem.

   Dim rs As ADODB.Recordset

   Dim cfx As New CfxDataAdo

   Dim x As New CrosstabProvider

   Set rs = GetAvgRTTrend

   cfx.Resultset = rs

   x.DataSource = cfx

   x.DataType(0) = CTDT_COLUMNHEADING

   x.DataType(1) = CTDT_ROWHEADING

   x.DataType(2) = CTDT_VALUE

   With fx

      .GetExternalData x

   End With

Thanks,

Rob

[Software FX]

This is caused by the CroosTab data provider. You are not defining the

Column Heading and Row Heading incorrectly.

Please contact our support dept. If you give them the structure of your data

and the result you want to get, they will be able to help you setup the

CrossTab data provider accordingly.

-- 

FP

Software FX, Inc.