Dim Chart As WinForm.Chart '定义一个图表变量
Dim Series As WinForm.ChartSeries '定义一个图系变量
Chart = e.Form.Controls("Chart1") ' 引用窗口中的图表
Chart.VisualEffect = True '加上这一行,让你的图表更漂亮
Chart.ChartType = ChartTypeEnum.Bar '图表1类型该为Bar(条形)
Chart.ChartType2 = ChartTypeEnum.bar '图表2类型该为Bar(条形)
Chart.ChartType3 = ChartTypeEnum.bar '图表3类型该为Bar(条形)
Chart.ChartType4 = ChartTypeEnum.XYPlot '图表4类型该为线形
Chart.DataSource = "统计表1" '设置绑定表
Chart.SeriesList.Clear() '清除图表原来的图系
Series = Chart.SeriesList.Add() '给图表1增加一个图系
For Each c As Col In Tables("统计表1").Cols
If c.Name = "净重_1" Then
Series = Chart.SeriesList.Add() '增加一个图系
Series.Text = c.Caption '设置图系的标题
Series.X.DataField = "时" 'X轴绑定到产品列
Series.Y.DataField = c.Name '设置Y轴的绑定列
End If
Next
Chart.SeriesList2.Clear() '清除图表原来的图系
Series = Chart.SeriesList2.Add() '给图表2增加一个图系
For Each c As Col In Tables("统计表1").Cols
If c.Name = "净重_2" Then
Series = Chart.SeriesList.Add() '增加一个图系
Series.Text = c.Caption '设置图系的标题
Series.X.DataField = "时" 'X轴绑定到产品列
Series.Y.DataField = c.Name '设置Y轴的绑定列
End If
Next
Chart.SeriesList3.Clear() '清除图表原来的图系
Series = Chart.SeriesList3.Add() '给图表2增加一个图系
For Each c As Col In Tables("统计表1").Cols
If c.Name = "净重_3" Then
Series = Chart.SeriesList.Add() '增加一个图系
Series.Text = c.Caption '设置图系的标题
Series.X.DataField = "时" 'X轴绑定到产品列
Series.Y.DataField = c.Name '设置Y轴的绑定列
End If
Next
Chart.SeriesList4.Clear() '清除图表原来的图系
Series = Chart.SeriesList4.Add() '给图表2增加一个图系
For Each c As Col In Tables("统计表1").Cols
If c.Name = "净重_4" Then
Series = Chart.SeriesList.Add() '增加一个图系
Series.Text = c.Caption '设置图系的标题
Series.X.DataField = "时" 'X轴绑定到产品列
Series.Y.DataField = c.Name '设置Y轴的绑定列
End If
Next
Chart.LegendVisible = True '显示图列
Chart.LegendCompass = CompassEnum.South '图列显示在南方(底端)
Chart.AxisY.Text = "净重_1"
Chart.AxisY2.Text = "净重_2"
Chart.AxisY3.Text = "净重_3"
Chart.AxisY4.Text = "净重_4"
Chart.AxisX.AnnoWithLabels = True '启用字符标示
Chart.VisualEffect = True '加上这一行,让你的图表更漂亮
Chart.LegendVisible = True '显示图列
Chart.LegendCompass = CompassEnum.South '图列显示在南方(底端)
Series.DataLabelText = "{#YVAL}"
Series.Length = 12 '新增图系包括10个数据点
Series.TooltipText = "X = {#XVAL}, Y = {#YVAL}"
For i As Integer = 0 To 11 '指定每个数据点的位置
Series.X(i) = i '指定水平坐标
Series.Y(i) = i + Rand.Next(5) '垂直坐标用随机数生成
Next
加好友 
发短信
Post By：2022/12/9 17:13:00 [只看该作者]
此主题相关图片如下：图表-002.png