data question

[adi]

Hi,

I'm not familiar with RadChart. I fiddle with it. I have a simple question now. I'd like to bind a simple DataTable to a Chart programmatically. The DataTable columns collection holds the values that I like to display as X axis and the Rows collection holds the values for the Y axis. How can I tell the RadChart to use the columns as X? I can't found something like 'use pivot'.

[Ves]

Hi adi,

Unfortunately, RadChart does not provide pivot functionality. Still, you can display such chart by adding the chart series and their items manually, here is an example:

DataTable tbl = new DataTable();
        DataColumn col = new DataColumn("Col1");
        col.DataType = typeof(double);
        tbl.Columns.Add(col);
        col = new DataColumn("Col2");
        col.DataType = typeof(double);
        tbl.Columns.Add(col);

        tbl.Rows.Add(new object[] { 2, 17 });
        tbl.Rows.Add(new object[] { 3, 19 });
        tbl.Rows.Add(new object[] { 4, 15 });

        RadChart1.PlotArea.XAxis.AutoScale = false;
        foreach (DataColumn column in tbl.Columns)
        {
            RadChart1.PlotArea.XAxis.AddItem(column.ColumnName);
        }
        foreach (DataRow row in tbl.Rows)
        {
            ChartSeries ser = new ChartSeries();
            RadChart1.Series.Add(ser);
            ser.Name = "Series " + ser.Index;
            foreach (DataColumn column in tbl.Columns)
            {
                ser.Items.Add(new ChartSeriesItem((double)row[column]));
            }
        }

Hope this helps.

Regards,
Ves
the Telerik team

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