RadChart Series Problem

[Rishi]

Hello Am finding an issue with additional series in my Radchart. Please help me.
Am trying to develop a XY-Axis chart with single series.
For this for this chart am distributing two database columns with X(Client ID) and Y(Client Account Balance) Axis.
And I would like to see only one Client Account Balance series, Not client Id series.
Unfortunately, automatically My chart displaying two serieses,i.e Client Id and Client Account Balance.

This issue Screwing me from past two weeks, I did all trials to resolve this, But I didn,t

From Aspx Code, Am not giving any input in series collections.
Please see below code.
Please Help!

<

 

 

telerik:RadChart AutoLayout="True" Height="450px" ID="CapacityRadChart"

 

 

 

runat="server" Skin="WebBlue" Width="935px" OnClick="CapacityRadchartClick">

 

 

 

<ClientSettings EnableZoom="True" ScrollMode="Both"/>

 

 

 

<Appearance>

 

 

 

<FillStyle MainColor="249, 250, 251">

 

 

 

</FillStyle>

 

 

 

<Border Color="160, 170, 182" />

 

 

 

</Appearance>

 

 

 

<Legend>

 

 

 

<Appearance Dimensions-Margins="1%, 1%, 1px, 1px"

 

 

 

Dimensions-Paddings="1px, 1px, 1px, 1px"

 

 

 

Position-AlignedPosition="Top">

 

 

 

<ItemTextAppearance TextProperties-Color="102, 102, 102">

 

 

 

</ItemTextAppearance>

 

 

 

<FillStyle MainColor="216, 222, 227">

 

 

 

</FillStyle>

 

 

 

<Border Color="160, 170, 182" />

 

 

 

</Appearance>

 

 

 

</Legend>

 

 

 

<PlotArea>

 

 

 

<YAxis AutoScale="True" AxisMode="Extended">

 

 

 

<Appearance>

 

 

 

<MajorGridLines Color="227, 227, 227" />

 

 

 

<MinorGridLines Color="227, 227, 227" />

 

 

 

<TextAppearance AutoTextWrap="False"/>

 

 

 

</Appearance>

 

 

 

<AxisLabel>

 

 

 

<TextBlock>

 

 

 

<Appearance TextProperties-Color="140, 140, 140" Position-AlignedPosition="TopLeft">

 

 

 

</Appearance>

 

 

 

</TextBlock>

 

 

 

</AxisLabel>

 

 

 

</YAxis>

 

 

 

<XAxis AutoScale="True" DataLabelsColumn="RIID's" MaxValue="0" Step="0">

 

 

 

<Appearance>

 

 

 

<MajorGridLines Color="227, 227, 227" Width="0" />

 

 

 

<TextAppearance AutoTextWrap="True" />

 

 

 

</Appearance>

 

 

 

<AxisLabel>

 

 

 

<TextBlock>

 

 

 

<Appearance TextProperties-Color="140, 140, 140" Position-AlignedPosition="BottomRight">

 

 

 

</Appearance>

 

 

 

</TextBlock>

 

 

 

</AxisLabel>

 

 

 

</XAxis>

 

 

 

<Appearance>

 

 

 

<FillStyle FillType="Solid" MainColor="">

 

 

 

</FillStyle>

 

 

 

</Appearance>

 

 

 

</PlotArea>

 

 

 

<ChartTitle>

 

 

 

<Appearance>

 

 

 

<FillStyle MainColor = "">

 

 

 

</FillStyle>

 

 

 

</Appearance>

 

 

 

<TextBlock Text="Capacity Delay" >

 

 

 

<Appearance TextProperties-Color="102, 102, 102"

 

 

 

TextProperties-Font="Arial, 7pt" Position-AlignedPosition="Bottom">

 

 

 

</Appearance>

 

 

 

</TextBlock>

 

 

 

</ChartTitle>

 

 

 

</telerik:RadChart>

 

Aspx.VBfile Code:

CapacityMonthlyRadChart.DataSource = ds.Tables.Item(7)

CapacityMonthlyRadChart.DataBind()

CapacityMonthlyRadChart.Series(0).DataXColumn =

 

"ClientId"

 

CapacityMonthlyRadChart.Series(0).DataYColumn =

 

"ClientAccountBalance"

 

    

[Yavor]

Hi,

If the original data layout does not meet your requirements well, you can take a different approach. You can omit setting the x Column, or prepare a separate data view, which contains only the data which you want to show. Attached to this message, is a small application, which handles a similar task.
Yet another option is to dynamically create the series:

http://www.telerik.com/help/aspnet-ajax/radchart-building-programmatic-create.html

I hope this information helps.

Kind regards,
Yavor
the Telerik team

[Rishi]

Thank You for the reply on it Yavor .

Assuming, in your previously attached application solution.binding of table result to chart is same as below.

radchartcontrole.Series(0).DataXColumn = "ID"

 

 

radchartcontrole.Series(0).DataYColumn = "Colmun1"
This is not working for me.


I've been sticking on this code from past few weeks, but not working well.
Am expecting the results on chart as.

What ever the data data coming from database as a table, I would like to show. on the chart.
Please find my one of my dataset image.In the attached image, Am having some -ve Values which has to go X-Axis on chart.
am fine with the column"Count_investigationid" which is going to Y-Axis. having the trouble to pull the values of column "CapacityDelay" onto the X-Axis dynamically. It is not showing the -ve values and giving showing the limitted x-scale points.

Example. If Count_Investigation has 10 rows, It is giving the X-Axis scale points from 1 to 10, which is leading to outof-sync of "CapacityDaley" Results.

FYI, I tried through X-Axis Min Values= -999999999 also didn't work.
    
Please Help.

Thank You,
Rishi.