RadChart Series Problem

Thread is closed for posting
3 posts, 0 answers
  1. Rishi
    Rishi avatar
    11 posts
    Member since:
    Mar 2012

    Posted 03 Apr 2012 Link to this post

    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"

     




        
  2. Yavor
    Admin
    Yavor avatar
    11 posts

    Posted 06 Apr 2012 Link to this post

    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
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Rishi
    Rishi avatar
    11 posts
    Member since:
    Mar 2012

    Posted 11 Apr 2012 Link to this post

    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.

     

Back to Top