主题：图系

你好！

取列3的文本作为X轴，Y轴值=列4 /列1，请帮忙改下Y轴代码

 

 

Dim Chart As WinForm.Chart '定义一个图表变量
Dim Series As WinForm.ChartSeries '定义一个图系变量
Dim tblr As DataTable = DataTables("表A") '定义一个变量tbl引用数据表
Dim lst As List(Of String) = tblr.SQLGetValues("列3","[列2] = '" & e.Form.Controls("TreeView3").SelectedNode.name &  "' and 列2 is not null")'获得产品名称集合
Chart = e.Form.Controls("Chart1") ' 引用窗口中的图表
Chart.ChartType = ChartTypeEnum.Bar '设置图表类型
Chart.SeriesList.Clear() '清除图表原来的图系
Chart.AxisX.ClearValueLabel                 '清除图表原来的水平坐标
Series = Chart.SeriesList.Add() '增加一个图系
Series.Length = lst.Count '设置图系的长度

For ii As Integer = 0 To lst.Count - 1 '指定每个数据点的位置
Dim r1 As Single = tblr.SQLCompute("SUM(列1)","[列2] = '" & e.Form.Controls("TreeView3").SelectedNode.name &  "'and [列3] = '" & lst(ii) & "' and 列2 is not null and 列1 is not null")
Dim r2 As Single = tblr.SQLCompute("SUM(列4)","[列2] = '" & e.Form.Controls("TreeView3").SelectedNode.name &  "'and [列3] = '" & lst(ii) & "' and 列2 is not null and 非列1 is not null")
Dim qq1B() As Single = {r1}
Dim qq2B() As Single = {r2}
Dim r() As Single = qq2B() / qq1B()
 Series.X(ii) = ii '指定水平坐标
    Series.Y(ii) = r(ii)

 Chart.AxisX.SetValueLabel(ii, lst(ii)) '指定字符表示
Next
Chart.HeaderText="增值与非增值比率"   '设置图表的上标题
Chart.AxisX.AnnoWithLabels = True '启用字符标示
Series.DataLabelText = "{#YVAL}"    '图中显示数据
Chart.VisualEffect = True           '图更漂亮
Chart.SeriesList(0).LineColor= Color.MediumBlue

Series.Y(ii) = r2 / r1