Hi,
I am using UltraChart 2009.2 version. Can we set the Source Column of X and Y axis from the DataTable?
E.g : Consider a Product Table with columns, name, cost, qty:
ultrachart1.DataSource = dt;
ultrachart1.DataBind();
ultrachart1.Axis.X = "name";
ultrachart1.Axis.Y = "cost";
Note: I wanted to create a dynamic 3D chart from code like ColumnChart3D, BarChart3D.
Can we create a 3D chart in a composite chart.
Can Series be used in non composite chart. If yes, how? any examples
Please help!!
Hi Madhukar,
I am attaching a small sample for your reference. If you have any questions please do not hesitate to ask.
Thank you for the quick response.
Both methods worked, but i would like to go with the NumericSeries method, as we can set which column to use.
Thanks for your help.
When binding to the chart, the string column gets automatically assigned as the label column and numeric columns are used as data columns. You can use series if you like, but you cannot use composite charts to render 3d charts. Here are two code snippets that uses chart binding and series binding. Both produce identical results:
DataTable dt = new DataTable();dt.Columns.Add("label", typeof(string));dt.Columns.Add("cost", typeof(double));dt.Columns.Add("qty", typeof(double));dt.Rows.Add("item 1", 29, 100);dt.Rows.Add("item 2", 33, 140);dt.Rows.Add("item 3", 28, 150);dt.Rows.Add("item 4", 35, 170);
ultraChart1.ChartType = ChartType.ColumnChart3D;
//option 1: bind data to the chartultraChart1.Data.IncludeColumn(2, false);ultraChart1.Data.SwapRowsAndColumns = true;ultraChart1.Data.DataSource = dt;ultraChart1.Data.DataBind();
//option 2: bind data to the seriesNumericSeries series = new NumericSeries();series.Data.DataSource = dt;series.Data.LabelColumn = "label";series.Data.ValueColumn = "cost";series.DataBind();ultraChart1.Series.Add(series);ultraChart1.Data.DataBind();