OWC StackColumn Chart

i created one stackColumn Chart which supposed to have nine item showing in the legend( For Item A to Item I) but it just show 8 item (Item A to Item H) and one Series9, i try to check this for few day but still cannot found the problem

Here is my source code for create this graph

Code:

---

            strSQL = "select columnA, columnB from Table Column "

            rsMFg.Open strSQL, cntdb
        if not rsMfg.EOF then

        '''''''''''''''''''''''''''''''''''''''''''''''''''''
        ' set graph object here
        set oChart = createObject("OWC.Chart")
        set c = oChart.Constants
       
            oChart.Clear

        oChart.Border.color = c.chColorNone
       
        ' Add a chart and set parameters for the chart
        oChart.Charts.Add
        dim jser        ' for series usega
        jser = 0
        x = 0
            '''''''''''''''''''''''''''''''''''''''''''''''''''''
               
            do while not rsMfg.EOF
       
            IF rsMfg("ColumnB")<> "" THEN
                Short = rsMfg("ColumnA")
            END IF
       
                strSQL1        =        "Select * from XXX"

          rsMfg1.Open strSQL1, cntDB
          if not rsMfg1.EOF then
                do while not rsMfg1.EOF
                    yQty(x) = cdbl(rsMfg1("DDD")
                    X = X + 1
                loop
          ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
          ' set graph Operation value here
          oChart.Charts(0).SeriesCollection.Add       
          set jSeries = oChart.Charts(0).SeriesCollection(jser)

          jSeries.Type = c.chChartTypeColumnStacked                       
          jSeries.Caption = Short
          jSeries.SetData c.chDimCategories, c.chDataLiteral, xDay
          jSeries.SetData c.chDimValues, c.chDataLiteral, yQty

          '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
        end if
        rsMfg1.Close                               
        rsMfg.MoveNext
          loop
    End if

---

Column table is the source to for display those item in the legend. I have to try to response.write it and it is ok, it show all 9 item.

anyone can help me??

need helping from u all.......I have try for the whole week, i still cant found where is the problem....

as you are still stuck on this, can you post as sample worksheet with this problem, but as we don't have the same data to create your chart it is difficult to see the problem

Here is the sample data for the Table Column


Column A Column B Column C
======== ======== ========
EFG 10 Cutting
EFG 20 #999
EFG 30 XXXX
EFG 40 JJJJJ
EFG 50 FFFF
EFG 60 KKKK
EFG 70 IIII
EFG 80 AAA
EFG 90 hhhh


I have try do in Excel, is it ok. But come to asp, it happen this problem. I attach with the source code