主题：Chart y轴没有按照从小到大 从底部往顶部排序……

此主题相关图片如下：12.png

怎么解决y数字不是从小到大 从底部往顶部排序呢？

怎么为什么会出现两个15呢？数值相同就只显示一个  然后柱形图中对应的相等即可

'生成Excel报表
Dim b As New XLS.Book
Dim t As Table = Tables("表A")
Dim s As XLS.Sheet = b.Sheets(0)
For c As Integer = 0 To t.Cols.Count -1 '添加列标题
    s(0, c).Value = t.Cols(c).Name
Next
For r As Integer = 0 To t.Rows.Count - 1 '填入数据
    For c As Integer = 0 To t.Cols.Count -1
        s(r +1, c).Value = t.rows(r)(c)
    Next
Next
'生成图表
Dim Chart As New ChartBuilder '定义一个图表变量
Dim Series As WinForm.ChartSeries '定义一个图系变量
Chart.DataSource = "表A" '设置绑定表
Chart.SeriesList.Clear() '清除图表原来的图系
Series = Chart.SeriesList.Add() '增加一个图系
Series.X.DataField = "第一列" 'X轴绑定到产品列
Series.Y.DataField = "第二列" 'Y轴绑定到数量列
Chart.PrintWidth = 120
Chart.PrintHeight = 60
s(t.rows.Count + 2,1).Value = New XLS.Picture(Chart.Image)
b.Save("c:\reports\test.xls")
Dim Proc As New Process
Proc.File = "c:\reports\test.xls"
Proc.Start()