MS Chart

Hai all,

I have this problem with MS Chart. First of all I would
like to show how I code it:

Dim Stud(,) As Object = New Object(,) _
{{"Student", "Final Mark Percentage"}, _
{"9 - 10 AM", 10}, _
{"10 - 11 AM", 10}, _
{"11 - 12 AM", 10}, _
{"12 - 1 PM", 10}, _
{"1 - 2 PM", 10}, _
{"2 - 3 PM", 10}, _
{"3 - 4 PM", 10}, _
{"4 - 5 PM", 10}}

What I want to ask are:
How to set the value dynamicaly? like for example using
for loop. As we can see above code that I add the value
to the object is fixed.

Thanks all
.

Relevant Pages

  • Re: Bug with Chart.Name?
    ... loop should "normally" return same as a For Each shape. ... PS * eg, rename a chartobject, copy it, group the pair, loop For Each ... Dim shp As Shape, chtObj As ChartObject, cht As Chart ... processed as you can see in the debug output, ...
    (microsoft.public.excel.charting)
  • Re: Bug with Chart.Name?
    ... .Chartobjects.Count loop ... Dim shp As Shape, chtObj As ChartObject, cht As Chart ... processed as you can see in the debug output, ...
    (microsoft.public.excel.charting)
  • RE: Chart Object - SeriesCollection property
    ... I have tried to set it using the count property and using a For loop however ... If you have more than one series on the chart, you need to get the count ... I have a Form that contains a graph that is based on employee work times ... .SeriesCollection.Border.Color = vbBlack ...
    (microsoft.public.access.modulesdaovba)
  • Re: Bug with Chart.Name?
    ... although most people might consider "For..Each" as the "normal" way to loop objects. ... Dim shp As Shape, chtObj As ChartObject, cht As Chart ... I know it might seem odd but actually, as your subject line suggests, there can be a bug of sorts when looping For Each with any object type at the 'DrawingObject' level; of which ChartObject is a sub type. ... > processed as you can see in the debug output, ...
    (microsoft.public.excel.charting)
  • Re: help me about this very simple stateflow chart
    ... i need intermediate values of a counter 'i' in "for" loop to trigger ... someother functionality in the other chart. ...
    (comp.soft-sys.matlab)