loop for chart creation ?

[Ace Master]

Hi.

 

I have a chart for displaying some data.

 

The problem is that I have a combo list from where I chose the chart to be displayed for 1 day, 3 days, 7 days, 10 days, 20 days and 30 days.

 

It is possible to have a �for loop� for generate dynamically the chart with 1 column, 3 , 5 .whatever ..

 

This is my code now.

 

 Dim Sales2(,) As Object = New Object(,) _
            {{"cheese spread", "Param 1"}, _
            {zile(6), info_for(6, unit, 1)}, _
            {zile(5), info_for(5, unit, 1)}, _
            {zile(4), info_for(4, unit, 1)}, _
            {zile(3), info_for(3, unit, 1)}, _
            {zile(2), info_for(2, unit, 1)}, _
            {zile(1), info_for(1, unit, 1)}, _
            {zile(0), info_for(0, unit, 1)}}
       chart2.ChartData = Sales2

 

thanks

 

I don't want copy paste (and change) for each option :)