RadHTMLChart plotting same series together

See more:

C#

VB

ASP.NET

Telerik

Hi all,

As I am in the midst of enhancing my report for my work, I am moving into telerik for better presentation and performance.

I am trying to plot a ColumnSeries chart, and sample data is as below:

Week Outlet1 Outlet2
1 $1.00 $3.00
2 $5.00 $9.99
3 $9.99 $10.00
4 $6.90 $12.00


I am creating each of the "Outlets" as per mention on top as a "New ColumnSeries" in order to be identified easily when plotting the chart. Code is as below:

For intCounter As Integer = 1 To dtDest.Columns.Count - 2 Step 1
            Dim NewSeries As New ColumnSeries
            NewSeries.DataFieldY = dtDest.Columns(intCounter).ToString
            NewSeries.Name = dtDest.Columns(intCounter).ToString
            NewSeries.TooltipsAppearance.Color() = System.Drawing.Color.White
            NewSeries.LabelsAppearance.Visible = False
            'NewSeries.StackType = HtmlChart.Enums.HtmlChartStackType.Normal

            chrtAllStores.PlotArea.Series.Add(NewSeries)
        Next

But the data representation is not as my ideal end, as it plots the chart grouping by the weeks instead, I would like them to be displayed grouping by outlet, so i can compare sales for each outlet in weeks, it's now clustered by weeks and not outlet.

Advice would be greatly appreciated! Thank you!