Forums Ultimate UI for ASP.NET Web Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Daryl
4110
Column Chart Series data
posted

I've been working with simple charting using UltraWebChart, but now I'm getting to multiple series data and can't get my series data to stay together. I'm grouping Quarterly data for 3 data types and building a datatable as my datasource as follows:

First i populate an array

array(0,0)="Cats"

array(0,1)="10"

array(0,2)="11"

array(0,3)="8"

array(1,0)="Dogs"

array(1,1) ="7"

array(1,2)="6"

array(1,3)="7"

array(2,0)="Total"

array(2,1)="16"

array(2,2)="20"

array(2,3)="10"

Then I add columns to the datatable as:

dt.Columns.Add("Period",GetType(System.String))

dt.Columns.Add("1Q FY09", GetType(System.Int64))

dt.Columns.Add("2Q FY09", GetType(System.Int64))

dt.Columns.Add("3Q FY09", GetType(System.Int64))

Then I add the rows as:

dt.Rows.Add(New Object() {array(0,0).ToString, array(0,1).ToString, array(0,2)ToString, array(0,3.ToString})

dt.Rows.Add(New Object() {array(1,0).ToString, array(1,1).ToString, array(1,2)ToString, array(1,3.ToString})

dt.Rows.Add(New Object() {array(2,0).ToString, array(2,1).ToString, array(2,2)ToString, array(2,3.ToString})

 

What I end up with is:

 

Swapping rows and columns didn't help and tried UseRowLabelsColumns, RowLabelsColumn=0, but that didn't help either.

Surely it is something fundamental I'm missing, right? Am I not building the datatable correctly? Please help!! Thanks much!