CHART_HIDDEN for series of different sizes

[User (Legacy)]

Im creating a table of values.  But the Series lengths are different sizes.

I want the values that shouldnt show up to not show up.  The documentation

says to utilize the CHART_HIDDEN property.  When I do it seems to have not

effect ???

Does anything appear to be wrong.

  cfxChart.Gallery = LINES

   cfxChart.LineStyle = CHART_SOLID

   cfxChart.OpenDataEx COD_VALUES, lngNumSeries, COD_UNKNOWN

   cfxChart.OpenDataEx COD_XVALUES, lngNumSeries, COD_UNKNOWN

'   cfxChart.OpenDataEx COD_VALUES, lngNumSeries, lngRecCount

'   cfxChart.OpenDataEx COD_XVALUES, lngNumSeries, lngRecCount

   j = 0

   Do While Not rec.EOF

     For i = 1 To lngNumSeries

       If Not IsEmpty(rec.Fields(i).Value) Then

          cfxChart.Series(i - 1).Xvalue(j) = rec.Fields(i).Value

          cfxChart.Series(i - 1).Yvalue(j) = rec.Fields(0).Value

       Else

          cfxChart.Series(i - 1).Xvalue(j) = 0

          cfxChart.Series(i - 1).Yvalue(j) = CHART_HIDDEN

          cfxChart.ValueEx(i - 1, j) = CHART_HIDDEN

       End If

     Next i

     rec.MoveNext

     j = j + 1

   Loop

  cfxChart.CloseData COD_XVALUES

  cfxChart.CloseData COD_VALUES

[Software FX]

Hello,

Have you tried just passing the recordset directly to ChartFX.  By default

an empty cell within a recordset is interpreted by ChartFX as Chart_Hidden.

You can create an XY chart with an ADO recordset by specifying how each

column in the recordset is using with our DataType property setting.  This

sample on our support web site demonstrates how to use the DataType feature

http://support.softwarefx.com/Samples/CfxIE/Data/Datatype.asp.

If you do not want to pass the recordset directly to ChartFX and you want to

continue to use the ValueEx method then I would recommend that you do not

declare OpendataEx twice for the Values and XValues.  This should be

declared only once for Value and only once for XValue.  Here is a sample on

our support web site that uses the Chart_Hidden feature

http://support.softwarefx.com/Samples/CfxIE/Data/XYHiddenPoints.asp.

JT

Tech. Support

561-392-2023

"Patrick" <pkuehn@thenexsysgroup.com> wrote in message

news:Yj$w5vfhCHA.1312@webserver1.softwarefx.com...

> Im creating a table of values.  But the Series lengths are different

sizes.

> I want the values that shouldnt show up to not show up.  The documentation

> says to utilize the CHART_HIDDEN property.  When I do it seems to have not

> effect ???

>

> Does anything appear to be wrong.

>

>

>   cfxChart.Gallery = LINES

>    cfxChart.LineStyle = CHART_SOLID

>    cfxChart.OpenDataEx COD_VALUES, lngNumSeries, COD_UNKNOWN

>    cfxChart.OpenDataEx COD_XVALUES, lngNumSeries, COD_UNKNOWN

> '   cfxChart.OpenDataEx COD_VALUES, lngNumSeries, lngRecCount

> '   cfxChart.OpenDataEx COD_XVALUES, lngNumSeries, lngRecCount

>    j = 0

>    Do While Not rec.EOF

>      For i = 1 To lngNumSeries

>        If Not IsEmpty(rec.Fields(i).Value) Then

>           cfxChart.Series(i - 1).Xvalue(j) = rec.Fields(i).Value

>           cfxChart.Series(i - 1).Yvalue(j) = rec.Fields(0).Value

>        Else

>           cfxChart.Series(i - 1).Xvalue(j) = 0

>           cfxChart.Series(i - 1).Yvalue(j) = CHART_HIDDEN

>           cfxChart.ValueEx(i - 1, j) = CHART_HIDDEN

>        End If

>      Next i

>      rec.MoveNext

>      j = j + 1

>    Loop

>   cfxChart.CloseData COD_XVALUES

>   cfxChart.CloseData COD_VALUES

>

>

>