Xaxis problem in Bar Chart

[Giri]

Hi,
       I am using radchart in my project.In  this  chart i am binding the datasource,assigning values for X and Y axis all in the runtime.The view of the chart is Bar.Here i have the problem is the y axis value is show correctly but in the x axis i am binding the month value.So actually it want to show the month name but in the x axis only the numbers will show like 1,2 etc......Here my codings are........

 Dim strsql As String

                Dim ds As New DataSet
                Dim conn As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
                Dim sqlconn As New SqlConnection(conn)
                strsql = "SELECT Month, QtyProduced FROM vw_productionyr WHERE year = " & Date.Today.Year
                Dim da As SqlDataAdapter = New SqlDataAdapter(strsql, sqlconn)
                da.Fill(ds)
              
                RadChart1.Series(0).Clear()
                RadChart1.Series(0).DataXColumn = "Month"
                RadChart1.Series(0).DataYColumn = "QtyProduced"
                             
                RadChart1.DataSource = ds
                RadChart1.DataBind()

                For i As Integer = 1 To RadChart1.Series.Count - 1
                    RadChart1.Series(i).Clear()
                Next

Help me to solve this problem and all i want to do in the runtime only.

[Matthew Bishop]

RadChart1.PlotArea.XAxis.AutoScale =

false;

least thats it in c#

[Ves]

Hi,

Indeed, Matthew's suggestion is correct. After setting AutoScale to false, you can use AddRange to add items to X axis. Then you can modify each item's TextBlock.Text property as per your requirements. Alternatively, you can wire BeforeLayout event. At this moment of the control lifecycle the axis items are created, so you can access them and modify them appropriately. Here is an example:

protected void RadChart1_BeforeLayout(object sender, EventArgs e)
    {
        RadChart1.PlotArea.XAxis.Items[0].TextBlock.Text = "My Text";
    }

Hope this helps.

Best regards,
Ves
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.