Jump to content
Software FX Community

CHART_HIDDEN for series of different sizes


User (Legacy)
 Share

Recommended Posts

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

Link to comment
Share on other sites

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

>

>

>

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...